Inserting a UTF8 String from ISO DB into UTF8 DB

[im2kul]

Hi,

I have an ISO DB in which my client tool goes and fetches the data, however, my destination DB in which my client tool has to writ ethe data to is a UTF8 DB. How can I do this? I have a bunch of UTF8 strings stuffed in to my ISO DB and I have extract those strings and insert them into a UTF8 DB (please note it should not be double converted). Can someone please give me an idea as to how to do this?

Thanks

 

[Marco Kalter]

The conversion will be done by the Oracle Client, to/from the character set as defined by the NLS_LANG key in the Oracle Registry.

 

[im2kul]

Hi Marco,

thanks for the quick response. I do understand that translation will be done by the NLS_LANG defined in the registry, but this will definately double convert the already UTF8 converted strings (from ISO DB) and thus it will produce garbled strings. Is there a way or do you know some library that I should use to convert UTF8 string from ISO DB to Unicode? Or will converting the strings to RAW Bytes (if you can tell me how to do this using DOA it would help me quite a bit) will do the job? UTF8 DB will convert Unicode strings to UTF8?

Thanks