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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

select * from pg_database;
--
Tatsuo Ishii

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

datname   datdba    encoding    datpath
------------------------------------------------
courses      26                  7      courses

I have tested with LATIN1 - LATIN5 and I haven't got any result...
I'd need the Spanish '?' (that is what I insert)...
Maybe I need to insert this character in a special way? The client is
set to the same encoding as the database is.

Thanks,
Rosa M. Carro

P.S. Could it be related to multibyte (or something similar)?

http://www.postgresql.org/search.mpl