Skip to Main Content

Java Database Connectivity (JDBC)

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!

Convert all varchars and text to nvarchar and ntext?

843854Feb 11 2005 — edited Feb 12 2005
I need to be able to store unicode data in my sql server database. As I understand it, the unicode data types ntext and nvarchar and nchar will be twice as large as their non-unicode counterpats text, varchar and char. For anyone else that has had to do this, do you convert ALL your character columns to the unicode types? Or do you try to be efficient and convert ONLY those that NEED to be converted? (this latter option sounds like it might be confusing in the code to have some columns that have this and others that don't). Is it worth the time to leave a handful of columns as non-unicode column types? What is best practices here?

Thanks!

Michael
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2005
Added on Feb 11 2005
8 comments
349 views