Re: JDBC driver, PGSQL 7.3.2 and accents characters

From: Tony Grant <tony(at)tgds(dot)net>
To: Davide Romanini <romaz(at)libero(dot)it>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC driver, PGSQL 7.3.2 and accents characters
Date: 2003-03-22 07:55:51
Message-ID: 1048319751.1581.3.camel@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Patrik Lundgren 2003-03-22 08:36:42 Re: spanish characters in postgres
Previous Message Barry Lind 2003-03-21 23:18:52 Re: JDBC driver, PGSQL 7.3.2 and accents characters