Skip site navigation (1) Skip section navigation (2)

Re: Mangled accented characters

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Yamir Encarnacion <yencarnacion(at)yahoo(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Mangled accented characters
Date: 2004-10-05 13:55:21
Message-ID: 1096984521.1678.211.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-jdbc by date

Next:From: David GagnonDate: 2004-10-05 14:29:36
Subject: OT? Database bridge for postgresql
Previous:From: Kris JurkaDate: 2004-10-05 06:40:25
Subject: Re: Installation Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group