Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Checking the double byte character

Author  Topic  sinva Starting Member 23 Posts Posted - 2010-05-25 : 22:13:40 Dear All, I am now migrating the data in SQL server to an Oracle Server. As I know Oracle Server uses UTF-8 to handle the Chinese Characters while SQL Server using double byte charater. I want to know is there any way to substring the doubl byte character to a UTF-8 byte length of 100? Thank you for all help