Strange characters

WorldWalker · Post by **WorldWalker** » 08.11.2009, 11:53

Hi,

I am using a db with character ENCODING = 'Latin9', and when I post a string including special characters (latin9) they are converted to strange ones.
Postgres 8.4.1
D2010 Pro
Zeos Rev.716
Did someone faced that before?
Thanks.

Post by **mdaems** » 11.11.2009, 23:51

Can't you switch the client encoding to UTF8, leaving the conversion to the db client/server protocol? Don't know enough about postgres, but that would be a possible solution with mysql.

Mark

WorldWalker · Post by **WorldWalker** » 12.11.2009, 06:27

Hi,
I've just tried this, it didn't work neither.

Thank you again.

MaGNa · Post by **MaGNa** » 23.11.2009, 14:34

Hi!
I have the same problem, a table with fields to varchar with collation "utf-8" and when keeping any text from Delphi, for example "ESPAÑA" it keeps "ESPAÃƒâ€˜", or "Varón" it keeps "VarÃƒÂ".

They can indicate like solving it to me? Thanks

KDeveloper2 · Post by **KDeveloper2** » 15.01.2010, 11:57

any news here to solve this problem?

yapt · Post by **yapt** » 16.01.2010, 15:16

On the ZConnection.Properties, add this:

codepage=UTF8

Or on the ZConnection BeforeConnect Event:

Code: Select all

procedure TForm1.ZConnection1BeforeConnect(Sender: TObject);
begin
  ZConnection1.Properties.Add('codepage=UTF8');
end;

Please, let me know if that runs as expected...

KDeveloper2 · Post by **KDeveloper2** » 17.01.2010, 19:06

Hi,
thanks for response, i´ve already add these property but it doesn´t work in mysql.
Any other idea?

yapt · Post by **yapt** » 17.01.2010, 20:23

I was speaking about PostgreSQL only. I don't know almost anything about MySQL.

Regards..

olivdaum · Post by **olivdaum** » 11.05.2010, 13:58

Hello,
I'm new in this discussion but not with the problem.
I have the same problem with PostgreSQL.

I tried a lot of things, and
codepage=UTF8 into ZConnection.Properties doesn't work, neither into ZConnection BeforeConnect Event.
Does some body have a new idea please ?

Thank you.