Mangled accented characters

Поиск
Список
Период
Сортировка
От Yamir Encarnacion
Тема Mangled accented characters
Дата
Msg-id 20041004235433.86666.qmail@web52303.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Mangled accented characters  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
I am having a problem with my accented characters
getting mangled.
Here is a snippet of the code I ran to reproduce the
problem
>>>Code starts
        Connection con =
DriverManager.getConnection(url, user, pwd);
        query = "INSERT INTO container (catparent,
catid, position, catname, cattype) values (2, 1, 1,
'Educaci��n', 0)";
        stmt = con.createStatement();
        stmt.execute(query);
        con.close();
<<<Code ends


My database is encoded using LATIN1
        List of databases
   Name    |  Owner   | Encoding
 directory | dpr      | LATIN1

When I do a Select using psql for the row above I get
the following:


 catid |  catname  | catparent | position | cattype |
description | keywords
-------+-----------+-----------+----------+---------+-------------+----------
     1 | Educaci��n |         2 |        1 |       0 |
            |

Could someone explain to me how to insert Educaci��n
as Educaci��n instead of as Educaci��n.  Thank you.

Yamir



__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: ResultSet.getBinaryStream nothing more than a ResultSet.getBytes()
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: error - driver -- postgresql 7.4.2 --Suse 9.0