Page 1 of 1
ZeosDBO 6.6.2 postgresql TEXT fields and '\' characters
Posted: 17.12.2007, 14:36
by bakter
when i duplicate all the '\' characters it works fine.
i modified the ZDataSetUtils.pas, but it's only a temporary sollution
Posted: 18.12.2007, 11:34
by mdaems
Thanks bakter.
Maybe you could check if you can use the TZConnection.DbcConnection.EscapeString() function instead of doing your own stringreplace for the backslashes only. That method should be more database independent.
I'm not a postgres user, so to fix this definitively I'll need input from your side.
For the implementation of the function above we only used the mysql API implementation. For other databases it's just the standard C encoding that's used.
Does postgres have an API call that takes a normal string and formats it so that it's readable for the database?
Mark