Thread: Inquiry From Form [pgsql]

Inquiry From Form [pgsql]

From
Jeancarlo Sott
Date:
I have a prolem with postgresql. I\'m using 
Madrake Linux 9.1 (brazilian portuguese) and 
when I access a database with java using the 
\'select\' command, I get wrong language 
settings, I should get \'ci�ncias\' (science) but I 
got \'ci?cias\'. Have I to configure something? 
Could it be a java problem? Note: with 
pgaccess I got the same problem. 



Re: Inquiry From Form [pgsql]

From
"Jeroen Habets"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Special characters are not supported by the ASCII character set.

Did you create the database using the --encoding option? (F.e. I use
createdb --encoding=UTF8)

You can check your server encoding using SHOW SERVER_ENCODING; in f.e. psql:

dbname=> SHOW SERVER_ENCODING;
 server_encoding
- -----------------
 UNICODE
(1 row)

(If you're installation returns SQL_ASCII the character set will be the
problem)

Jeroen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (MingW32)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAj6xoB8ACgkQ8hYvs/2oJvLSvwCbB75sBX4ewPdKwEboZ+yfAev/
oLEAnjf56UNCObgrr0YdGCO27ipAEbtk
=KLHv
-----END PGP SIGNATURE-----