APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

losing NATIONAL CHARACTERS(blob->clob->table). unistr?

523292Aug 22 2006 — edited Aug 25 2006

Hello!

I have a problem with national characters. My example is as follows:

1. A csv file is uploaded from disk to htmldb_application_files
2. This BLOB is then converted to CLOB with dbms_lob.converttoclob()
3. Data from this CLOB is copied to PL/SQL array.
4. From PL/SQL array to table in database.

The problem: Either data copied to table in database loses national characters (display strange characters instead of national), or if I set my national character set id as an argument of dbms_lob.converttoclob() function I have an error - says that file is inconvertible.

What is wrong? How can I solve my problem? Can unistr() help somewhere? Any ideas?

Tom

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2006

Added on Aug 22 2006

#apex-discussions

4 comments

963 views