In Sql server if i have a varchar field of length 12, if i enter 12 chinese characters, it fails. In Oracle there is a setting nls_length_semantics.If you put char in nls_length_semantics , it takes 12 characters irrespective of english(one byte) or chinese(doublr byte).
Is there any similiar setting for Sql server?
Did you try nvarchar(12) ?
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||I want to make it work on varchar . In Oracle i don't need to use nvarchar.Just using nls_length_semantics is enough.|||There is no way to do the same as Oracle in SQL Server. The only sure way is to to truncate the data before you insert.
No comments:
Post a Comment