Re: PostgreSQL JDBC Driver versus Encoding

João Paulo Pires wrote:
>
> Hello,
>
>
>
> I have a PostgreSQL database which encoding is SQL_ASCII.
>
> I inserted information into that database from a MySQL database, using
> Java code, which encoding is UTF-8, and the information in the
> destination database has some strange characters related with encoding
> problems.
>
>
>
> There is any additional parameter that we can consider in the
> PostrgreSQL connection string to deal with those problems?
>
> The problem should be related with the encoding used to connect to
> MySQL database?
>
>
>
you can't encode all symbols in UTF-8 with simple ASCII.   Symbols that
are the same will translate but ASCII only has 200 or so glyphs.  you'll
need to convert the database to UTF-8, then redo your inserts.