Skip site navigation (1) Skip section navigation (2)

Charset and encoding

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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



Responses

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 WengDate: 2001-05-09 01:16:56
Subject: Is this possible?

pgsql-general by date

Next:From: Keith SiuDate: 2001-05-09 10:51:01
Subject: Drop view
Previous:From: Renaud ThonnartDate: 2001-05-09 09:13:39
Subject: Re: Questions about indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group