Re: Mangled accented characters

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