Re: Mangled accented characters - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Mangled accented characters
Date
Msg-id 1096984521.1678.211.camel@localhost.localdomain
Whole thread Raw
In response to Mangled accented characters  (Yamir Encarnacion <yencarnacion@yahoo.com>)
List pgsql-jdbc
Yamir,

You should review the archives looking for encoding unicode.

The short version is that internally java uses unicode, and so does the
driver.

Dave
On Mon, 2004-10-04 at 19:54, Yamir Encarnacion wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer
519 939 0336
ICQ # 14675561
www.postgresintl.com


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Installation Question
Next
From: "David Gagnon"
Date:
Subject: OT? Database bridge for postgresql