Zeoslib Portal

it's seems that GetRawString return already decoded string - called here ZDbcPostgreSqlUtils.DecodeString doubles decoding and finnaly result is wrong, especialy when saved string conatins '\' char.... i confirm that string is saved encoded by EncodeString - mayby postgre libpq do this decode - in "pgadmin III query" 1.4.1 strings is returned also without saved "escapes"

i have this on pg 8.0 and pg 8.1 on windows - zeos compiled from cvs with d2005 and d2006

when i change :
function TZPostgreSQLResultSet.GetString(ColumnIndex: Integer): String;
begin
Result := GetRawString(ColumnIndex);
end;
all strings are returned correctly

it's occur only on mine installation ?

i was writing to post the same problem as you. i get the error with pg 8.0, delphi7, windows xp with the cvs version as to 13/10/2005.

now that i know how you corrected the problem, i'm going to modify my source and recompile.

hope the problem to be corrected in next versions of the lib.

thank you

Please try cvs version and let us know if it is still not working correctly.

Note that EncodeString() in is characterset unaware. This unawareness encodes some multibyte characters for TEXT/VARCHAR columns incorrectly.

Regards,

CN

Hi,

cvs version will also fail. We are currently working on a solution to solve this problem.

Regards.