Skip to Main Content

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!

corrupted korean characters

703626May 26 2009 — edited May 27 2009
Iam not able to save korean characters in database.

1.I was using korean characters in a database. The korean characters were saved in fields of type varchar/nvarchar2.
2.Due to some reason the server is restarted and now Iam not able to enter new korean characters.
3.The korean characters which are already entered in the fleld of type varchar is corrupted and the korean characters which were entered in the field of type nvarchar2 is not corrupted.
4.But Iam not able to enter new korean characters in fields of both types(varchar/nvarchar2)

Some NLS_Database_parameters:

NLS_DATE_LANGUAGE:AMERICAN; NLS_SORT:BINARY; NLS_CHARACTERSET:WE8ISO8859P1 NLS_NCHAR_CHARACTERSET:AL16UTF16; NLS_LANGUAGE:AMERICAN; NLS_TERRITORY:AMERICA

Note that I was able to save Korean characters earlier and after server restart Iam not able to save it now.

What could be the possible problem??
This post has been answered by Srini Chavali-Oracle on May 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2009
Added on May 26 2009
9 comments
1,358 views