| From: | Rosa Maria Carro Salas <rosa(dot)carro(at)ii(dot)uam(dot)es> |
|---|---|
| To: | pos2 <pgsql-novice(at)postgresql(dot)org>, postgres <pgsql-general(at)postgresql(dot)org> |
| Subject: | Charset and encoding |
| Date: | 2001-05-09 09:45:52 |
| Message-ID: | 3AF911D0.EF3997FC@ii.uam.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Hello,
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
obtain
"Se ñales".
Does anybody knows what is happening? Where can I find information
about this?
Thanks in advance,
Rosa M. Carro
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Siu | 2001-05-09 10:51:01 | Drop view |
| Previous Message | Renaud Thonnart | 2001-05-09 09:13:39 | Re: Questions about indexes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Naujock | 2001-05-09 11:47:32 | Looking for good reference materials for SQL programming. |
| Previous Message | Wei Weng | 2001-05-09 01:16:56 | Is this possible? |