[ANN] libDatabase 2.0.1.20

[Trevor DeVore]

On Feb 17, 2006, at 12:17 PM, Pierre Sahores wrote:

> Indeed, i'm very interested by your libDatabase solution and i will  
> test it extensivelly as soon as possible. She is probably more  
> suitable than mine in about pedagogic tasks. Thanks for your work  
> on this great lib. I will report you how she works for me and some  
> collegues i'm, at this time, working with on a Web GIS system.

Pierre,

Thanks.  I would be very interested to get your feedback.  Question -  
Do you know what the accepted form of escaping strings for insertion  
into the PostGreSQL database is?

I don't use PostGreSQL myself but I've read information that says  
PostGreSQL supports C-style escaped characters (\f, \r, etc.) but  
that this was going to be deprecated and you only need to escape  
single quotes with '' and that to use escaped characters you should  
prefix the value to insert with an "E" (or something like that).   
Right now libDatabase uses the escape characters, but I'm thinking it  
should just escape the single quote.


-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com