Re: JDBC driver, PGSQL 7.3.2 and accents characters

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