On Mon, 9 Aug 2004, Dino Nardini wrote:

> Hello there,
> 
> Is there no way to force the JDBC driver to simply pass the data as 
> SQL-ASCII, or ignore the encoding altogether?

No because Java itself needs it correctly encoded the JDBC driver needs to 
make that happen.

> I tried to dump and restore the database with UNICODE encoding but get 
> errors on restore because there is quotes/double quotes within some of the 
> text data.  Is there an encoding that will handle both french language 
> characters and quotes/double quotes?
> 

I've seen this problem with Microsoft "smart" quotes that are angled, but 
there should be no problem with plain ' and ".  When doing the dump / 
restore you may need to actually convert the data from whatever encoding 
you were using with something like iconv.  If you are just struggling with 
the quotes perhaps a simple search and replace would be fine.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to