Search found 4 matches

by yesod
01.11.2009, 20:06
Forum: ZeosLib 7.0 Beta Forum
Topic: Character problem using postgre
Replies: 6
Views: 1424

Solved

Using ENCODING = 'UTF8' in postgre and setting

Connection.Properties.Values['codepage']:='UTF8';
Connection.Properties.Values['client_encoding']:='UTF8';

solved the problem.

Seems you cannot use WIN1252 anymore.
by yesod
30.10.2009, 05:11
Forum: ZeosLib 7.0 Beta Forum
Topic: Character problem using postgre
Replies: 6
Views: 1424

Character problem using postgre

I use Postgre with ENCODING = UTF8 LC_CTYPE = French_Canada.1252 In pgAdmin the accent é,è seems to be saved correctly. When i read the value in Delphi 2009 using Zeos like this QueryTable.Fields[1].AsString I get faulty charaters for the accent. I've tried QueryTable.Fields[1].AsAnsiString but I ge...
by yesod
16.10.2009, 01:51
Forum: ZeosLib 7.0 Beta Forum
Topic: Connection problem Delphi 2009 - postgresql-8.4.1-1
Replies: 4
Views: 740

It seems it's the latest stable version...
by yesod
07.10.2009, 17:15
Forum: ZeosLib 7.0 Beta Forum
Topic: Connection problem Delphi 2009 - postgresql-8.4.1-1
Replies: 4
Views: 740

Connection problem Delphi 2009 - postgresql-8.4.1-1

--------------------------- Debugger Exception Notification --------------------------- Project prjGMCuisine.exe raised exception class EZSQLException with message 'SQL Error: unexpected response from server; first received character was "unexpected response from server; first received characte...