From: | Yamir Encarnacion <yencarnacion(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Mangled accented characters |
Date: | 2004-10-04 23:54:33 |
Message-ID: | 20041004235433.86666.qmail@web52303.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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,
'Educacin', 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 | Educacin | 2 | 1 | 0 |
|
Could someone explain to me how to insert Educacin
as Educacin instead of as Educacin. Thank you.
Yamir
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Michael G. Flanigan | 2004-10-05 06:29:01 | Installation Question |
Previous Message | Oliver Jowett | 2004-10-04 23:39:22 | Re: ResultSet.getBinaryStream nothing more than a ResultSet.getBytes() |