November 16, 2006 at 3:48 pm
Hi Everyone,
I load data every day from Sybase to SQL server 2000 and sybase database has some special characters in the database. I never had issues with special characters in reading/storing them SQL 2000 tables . We recently migrated our database from SQL 2000 to SQL Server 2005 and now SQL 2005 database engine is reading special characters wrong and storing them in different format. I would really appreciate if anyone can through their ideas/suggestions to resolve this issue.
Thank you
Bhushan
November 16, 2006 at 4:02 pm
In my last place of employment we used both Sybase and SQL Server. Everything worked well as long as we kept the collation (code page, for us old folks) the same. In our case, we had them both set to cp_850 case insensitive, accent insensitive. That's not SQL Server's default set, so if your old SQL Server had a collation that matched your Sybase instance and your new SQL Server was installed using the default, that would explain your different experience with the different versions of SQL Server.
What are you using to move the data between the two?
April 3, 2007 at 6:05 pm
Either change character set or use N before posting data into the field. You insert would look like
insert into Temp (desc) values (N'Test').
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply