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.
Search found 4 matches
- 01.11.2009, 20:06
- Forum: ZeosLib 7.0 Beta Forum
- Topic: Character problem using postgre
- Replies: 6
- Views: 1424
- 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...
- 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
- 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...