Re: pg jdbc driver

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