[postgis-users] encoding question

[Gustavo Henrique Sberze Ribas]

> But why in the postgresql admin it show accent correctly ?

  It probably uses the default OS encoding, which luckily is the same
encoding used to store the bytes. :) Try entering some text in Cyrillic 
or Japanese and you'll see the mess you're heading to. ;)  

regards,
Gustavo 

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