On Tuesday, August 12, 2014 11:20:58 PM UTC-3, Keith Campbell wrote:
>
> This might be easier to do on the server side.
> Many DBMS, including MySQL and PostGreSQL, support encoding conversions.
>
> eg convert('my_string', 'UTF8', 'ISO_8859_2')
> SELECT CAST(_latin1'test' AS CHAR CHARACTER SET utf8)
>
>
Thanks, it works ! For the record, the character encoding of our oracle DB
was WE8MSWIN1252, and to convert I just had to use:
SELECT CONVERT(col_name,'UTF8','WE8MSWIN1252') from ...
in the query.
