Great – thanks for putting that on the record. It may well be useful to someone in the future!
> On Aug 13, 2014, at 10:02 AM, Frederico Novaes <[email protected]> > wrote: > > > >> 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.
