Re: Unicode problem ??? - Mailing list pgsql-general

From Priem, Alexander
Subject Re: Unicode problem ???
Date
Msg-id 2A07EC2D0BC2774AAD6F74769F60D52A083304@ahmose.cict_ad.nl
Whole thread Raw
In response to Unicode problem ???  ("Priem, Alexander" <ap@cict.nl>)
Responses Re: Unicode problem ???
List pgsql-general
Hi Stijn,

I tried adding "set client_encoding to 'LATIN1'" to the Connect Settings of
psqlODBC. It didn't help. I still get the same weird characters when I look
at the data using SQL explorer.

Could this be due to the fact that the database was CREATED using SQL_ASCII
encoding? Maybe your solution only works when the database was created using
LATIN1 or UNICODE encoding.

The strange thing is that everything is FINE when I use phpPgAdmin to look
at the data, so there must be a conversion problem somewhere in the ODBC
layer...

Maybe I'll just try recreating the database using UNICODE or LATIN1 encoding
tomorrow. UNICODE seems the best, right? Or does LATIN1 have more
possibilities than UNICODE?

Groeten vanuit Veenendaal,

Alexander.


pgsql-general by date:

Previous
From: Michael Chaney
Date:
Subject: Re: [OT] Tom's/Marc's spam filters?
Next
From: Andrew Sullivan
Date:
Subject: Re: plan-reading extensive tutorial?