[postgis-users] encoding question

[Gustavo Henrique Sberze Ribas]

Hello,

  SQL_ASCII is for 7-bit text data only, if you need to store text in 
French use LATIN1 instead (or UNICODE).

  With SQL_ASCII there is no restriction on what data can be entered 
and you can get yourself in a real mess with different clients entering 
data in different encodings. 

  Java has no clue about how to translate back the extended characters. 
What charSet will it use? What was the original encoding? Of course, you
can force the use of a particular encoding against a stream of bytes and
keep your database in SQL_ASCII but I strongly advise against it.


regards,

Gustavo 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Gilbert, Antoine
Sent: Monday, January 30, 2006 2:59 PM
To: PostGIS Users Discussion
Subject: [postgis-users] encoding question


Hi

I have a postgresql database, the encoding of the database is SQL_ASCII

When I use the postgresql driver, I have problem retrieving special characters that 
display correctly in the postgres admin.

Any idea ?

Antoine