Re: pg jdbc driver

Hello there,

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

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?

Cheers... Dino


At 08:23 PM 08/08/2004 -0500, Kris Jurka wrote:


>On Sun, 8 Aug 2004, Dino Nardini wrote:
>
> > However, when I tested the same data with ColdFusion MX (built on a Java
> > platform), I ran into problems.  The french characters were either
> throwing
> > "Invalid character..." errors, or displaying as garbage.  I'm guessing
> that
> > CFMX was trying to convert the characters from SQL_ASCII to something else
> > (UTF-8?) somewhere between the database and the web page.
>
>The invalid character data errors are coming from the JDBC driver.  When
>it connects to the database it asks the server to send it data using UTF-8
>regardless of the actual database encoding.  The server cannot convert
>SQL_ASCII to UTF-8 and simply returns the SQL_ASCII data.  The JDBC driver
>is expected UTF-8 data and chokes on this, so as you mentioned you will
>need to dump and restore into a database with a "real" encoding.  This
>doesn't necessarily have to be unicode, but often makes the most sense.
>
>Kris Jurka

_____________________________________
Rivendell Software - Dynamic Web Solutions
http://www.rivendellsoftware.com
Tel 902.461.1697
Fax 902.461.3765