Thread: Documentation on standard conforming strings?
Hi, I don't yet properly understand the conforming strings implementation that came in 8.3 The manual (to me at least) has been a little imprecise in describing the implications for correctly inserting data with this enabled without getting back a plethora of warnings, or having the inserts fail completely. Is anyone aware of a good "how to" document on conforming strings covering such topics as: - Valid quoting methods and when the various ones should be used - Criteria for warnings (in some instances it seems you can get warnings about them no matter how 'safely' you insert? I.e., I know I'm likely to still be doing things wrong...) (- Any coverage of DBD::Pg's capabilities would be a great bonus) I realise this is a little vague, but unfortunately, so too is my understanding based on what I've read in the documentation thus far... Cheers, Preston.
Preston de Guise wrote: > I don't yet properly understand the conforming strings implementation > that came in 8.3 The manual (to me at least) has been a little > imprecise in describing the implications for correctly inserting data > with this enabled without getting back a plethora of warnings, or > having the inserts fail completely. > > Is anyone aware of a good "how to" document on conforming strings > covering such topics as: > > - Valid quoting methods and when the various ones should be used > - Criteria for warnings (in some instances it seems you can get > warnings about them no matter how 'safely' you insert? I.e., I know > I'm likely to still be doing things wrong...) > (- Any coverage of DBD::Pg's capabilities would be a great bonus) I'll try to describe it in a few simple lines: - with standard_conforming_strings=off, backslashes in string constants are always interpreted as escape characters. - with standard_conforming_strings=on, backslashes in string constants are interpreted as escape characters *only* if the string constant is preceeded by an E. - The warnings are only about the first case; they warn you that your backslash characters are interpreted as escape characters even though the string is not preceeded by E. I don't think there's anything special to consider for DBD::Pg. Yours, Laurenz Albe