Collation change - SQL Server Forums

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

Old Forums

CLOSED - General SQL Server

Collation change

Author

Topic

rkrishnav9
Starting Member

5 Posts

Posted - 2004-07-20 : 05:19:50

Hi

I have created a test database. and changed the collation to Japanese_CI_AI using "alter databse test collate Japanese_CI_AI " command. Created a table with a column xxx datatype varchar and if i try to insert a japnese character in this column its giving error. Can any body tell why this is happening?

I am running sql server 2000
alter command run successfully.

Thanks
Ramakrishna

mr_mist
Grunnio

1870 Posts

Posted - 2004-07-20 : 05:52:54

My guess would be that you need to use NVARCHAR instead of VARCHAR.

You only need to post one copy of your threads, by the way.

-------
Moo. :)

rkrishnav9
Starting Member

5 Posts

Posted - 2004-07-20 : 07:02:54

Thanks Moo! But I have another database where it is accepting for varchar also. the difference is here both the OS and Sql Server are with Japnese collation. In other system the OS is different and I changed only the databse collation, then it is not working.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-07-20 : 07:47:13

rkrishnav9

You are making more work for me with your crossposting

Damian

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-20 : 08:02:54

quote:
Originally posted by rkrishnav9

Thanks Moo! But I have another database where it is accepting for varchar also. the difference is here both the OS and Sql Server are with Japnese collation. In other system the OS is different and I changed only the databse collation, then it is not working.

Well, that would probably make a big difference on whether it would accept the Japanese characters. It shouldn't accept Japanese if you don't have the OS set to the same thing. Try NVARCHAR.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources