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