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.
| Author |
Topic |
|
LacOniC
Starting Member
29 Posts |
 Posted - 2008-02-28 : 10:44:30
|
| Hi.I had an SQL 2000 database with Turkish collation. (Note: Default database collation was Latin)Today i transfered data from that to SQL 2005 with Latin collation.There is no problem with old data. I transfered them correctly. But when i insert/update at new database, Turkish characters change to Latin. (Like i->i, g->g)When i put an N before the value, it works. For example INSERT INTO T1 (A) VALUES (N'A')Must i put N to all of them? I think not. What can be the solution?Note: Database for Snitz Forums like here. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-28 : 10:46:56
|
| Why you set up 2005 database with Latin collation when your old database collation was Turkish?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
LacOniC
Starting Member
29 Posts |
Posted - 2008-02-28 : 10:57:38
|
quote:
Originally posted by harsh_athalye
Why you set up 2005 database with Latin collation when your old database collation was Turkish?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
I tried to setup Community Server (I will migrate to it in future). It can't be setup Turkish database because of collation. |
|
|
|
|
|
|
Collation Problem After Migration (2000 to 2005)