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!

NLS_LENGTH_SEMANTICS (difference between byte and char)

BaffyMar 11 2009 — edited Mar 11 2009

Hi all,

If any of you out there has ever done an upgrade, and imported a database with nls_length_semantics set to bytes into another database with nls_length_semantics set to char, please let me know your experience. I need a good grasp of what effect this will have in the new database.

Please, give me explanation using real data (eg data in address column longer than 32 characters were truncated to 8, or just didn't load at all etc etc)

Thanks in advance.

This post has been answered by JustinCave on Mar 11 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2009

Added on Mar 11 2009

#general-database-discussions

4 comments

964 views