[postgis-users] encoding question

[Gilbert, Antoine]

But why in the postgresql admin it show accent correctly ?

-----Original Message-----
From: Gustavo Henrique Sberze Ribas [mailto:gribas at cpqd.com.br] 
Sent: January 30, 2006 12:43 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] encoding question

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users