ZeosDBO 6.6.2 postgresql TEXT fields and '\' characters

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
bakter
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 14.10.2005, 13:42

ZeosDBO 6.6.2 postgresql TEXT fields and '\' characters

Post by bakter »

when i duplicate all the '\' characters it works fine.
i modified the ZDataSetUtils.pas, but it's only a temporary sollution
You do not have the required permissions to view the files attached to this post.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
Post Reply