Solution: UCS2 / UTF8 / Oracle / Fail to convert between UTF8 and UCS2

Hello,

i have in the past the same problem, with "Fail to convert between UTF8 and UCS2".
The data came from MS Access (Unicode UCS2) to Oracle (NLS_LANG: AMERICAN_AMERICA.UTF-8).
To resolve the problem i work with convert function from oracle and make a error.
I would convert from UFT8 to UTFE and from UTFE to UTF8, but i convert from UTFE to UTF8 and from UTF8 to UTFE and it works!

Solution:
You have data from another datasource in your Oracle database and have problems, try this!

UPDATE <table1> SET
<column1> = CONVERT(<column1>,'UTFE','UTF8);
-- and back
UPDATE <table1> SET
<column1> = CONVERT(<column1>,'UTF8','UTFE);

SEVERAL DIGITS CAN BE CHANGE OR LOST, BUT THE MOST DATA WAS CLEAN NOW. I HAVE NOT CHECK THIS FOR OTHER CHARACTER SETS! greetings,
lemmes
(Sorry, my english is not so good:-)) Received on Fri Jul 05 2002 - 06:25:40 CDT