[Java lista] postgresql java linux charset

[zamek]

hello,

On Tuesday 10 March 2009 18.19.02 CoL wrote:
> mint minden adatbázisnál, a collation mondja meg a rendezést. lc_collate
> pg-be. Ezt be kell állítani a megfelelőre az initdb-nél.
> http://www.postgresql.org/docs/8.3/static/locale.html
Ott meg nem tartunk:)

Eloszor legyen utf.

A locale -a kimenete:
locale -a
C
en_US.utf8
hu_HU
hu_HU.iso88592
hu_HU.utf8
hungarian
POSIX

a postgres.conf-ban az idevago resz:
#client_encoding = ascii		# actually, defaults to database
					# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'hu_HU'			# locale for system error message
					# strings
lc_monetary = 'hu_HU'			# locale for monetary formatting
lc_numeric = 'hu_HU'			# locale for number formatting
lc_time = 'hu_HU'				# locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.hungarian'

ezeken kivul nem enged mas lc_* valtozot allitani. Probaltam a 
client_encoding-ot is allitani, de nem hagyta:
Error: Invalid line 436 
in /etc/postgresql/8.3/main/postgresql.conf: »client_encoding = utf-8        
# actually, defaults to database

Nagyon ugy tunik, hogy maga a Postgresql jol kezeli az utf-et, a java kliens 
rongalja el.

psql-bol, ill. pg_dump-pal jol mukodik.

A tora, kpogre es a sajat jdbc driver-en keresztul hibazik.
A Java:
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) Server VM (build 11.0-b15, mixed mode)

a postgresql drivert probaltam mind jdbc3, jdbc4-et is.

-- 
 thx,
 ----------------------------------
 Zoltan Zidarics programmer
 PTE-PMMFK H-7621 Pecs, Boszorkany u. 2. Hungary
 E-Mail: zamek at vili.pmmf.hu
 ----------------------------------