Oracle Database Discussions

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!

Storing chinese characters

605321May 30 2008 — edited Jun 1 2008

Hi,

We have a shanghai feed which stores Chinese characters in Oracle database. We have defined a column with data type VARCHAR2(80). We are pulling data and storing into this column from seebeyond (Middle ware).

We are pulling 80 characters but getting "value too large for the column" error. I heard that chinese characters take 2 byte for each character.

How to overcome this issue. Is there a way to reduce the chinese character to 1 byte.

Pls help me out

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2008

Added on May 30 2008

#general-database-discussions

4 comments

2,768 views