I have defined a database with the encoding SQL_ASCII. I fill the
database by using embedded SQL. When I insert the value "Señales", it is
correctly inserted. I read the correct value by typing the query in
postgres, but when I access this database from a Java program, via JDBC,
I obtain the value "Seqales". The LANG variable is set to "es_ES"
(spanish) which I suppose is OK.
I have changed this database encoding to LATIN1 and set the client
characterset to LATIN1 by typing \encoding LATIN1.
Now when I access the data from postgres interface I obtain
"Se(82f1)ales", and when I get the value through the Java program, I
Does anybody knows what is happening? Where can I find information
Thanks in advance,
Rosa M. Carro
pgsql-novice by date
|Next:||From: Eric Naujock ||Date: 2001-05-09 11:47:32|
|Subject: Looking for good reference materials for SQL programming.|
|Previous:||From: Wei Weng||Date: 2001-05-09 01:16:56|
|Subject: Is this possible?|
pgsql-general by date
|Next:||From: Keith Siu||Date: 2001-05-09 10:51:01|
|Subject: Drop view|
|Previous:||From: Renaud Thonnart||Date: 2001-05-09 09:13:39|
|Subject: Re: Questions about indexes|