Re: JDBC driver, PGSQL 7.3.2 and accents characters - Mailing list pgsql-jdbc

From Tony Grant
Subject Re: JDBC driver, PGSQL 7.3.2 and accents characters
Date
Msg-id 1048319751.1581.3.camel@vaio
Whole thread Raw
In response to Re: JDBC driver, PGSQL 7.3.2 and accents characters  (Davide Romanini <romaz@libero.it>)
List pgsql-jdbc
On Sat, 2003-03-22 at 00:11, Davide Romanini wrote:

>
> You surely are right, but... my data is already stored in the database.
> And when I work with them with psql or the odbc driver (linking tables
> in M$ Access) my accents are there without any problem. Why the jdbc
> driver doesn't work while the others program all work?

Because they aren't escaped automatically.

Dreamweaver JSP does it right. I have added a function to make searching
with accents transparent too. One thing I am still having problems with
is inserting ' into the database. My client is escaping manually as in
\'

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL


pgsql-jdbc by date:

Previous
From: "Mario Rodriguez Villanea"
Date:
Subject: special characters
Next
From: "Patrik Lundgren"
Date:
Subject: Re: spanish characters in postgres