Database Software

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!

nvarchar2 to nclob

826821Dec 27 2010 — edited Jan 3 2011

Hi.

I am about to change a column from type nvarchar2 to nclob and i have problem.

changing a column to a lob type does not work so i tried to create a new column with a temporary name, copy the data from the nvarchar2 column to the nclob column, drop the nvarchar2 column and finally rename the nclob column. my problem is copying the data. i don't know why but the strings are copied as single-byte but i need multi-byte. i read through the documentation but all i could find was that nvarchar and nclob basically use the same character encoding (which is utf-16 in my case). i tried to use the functions TO_NCLOB() and TO_MULTI_BYTE() and combinations of both but it didn't work.

i used this statement for copying the data: UPDATE mytablename SET nclobcolumn = nvarcharcolumn;

can anyone help me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2011

Added on Dec 27 2010

#database-key-features, #globalization-support

10 comments

1,809 views