This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Help! In SQL server the unique constraint is case insensitive?Karen and kaRen are the same when it is a primary key in SQL Server?
-elac(elac);
2003-1-19
{68}
(#986131@0)
-
that depends on how you set up your collation in the database. If collation setting is case insensitive, the answer to your Q is yes, otherwise N.
-yangn(Raymond);
2003-1-19
(#986222@0)
-
如果有SQL SERVER就直接找你肯定就没问题了.... :-）
-lazycod(沧海一笑);
2003-1-19
(#986224@0)
-
岂敢，岂敢。：）
-yangn(Raymond);
2003-1-19
(#986337@0)
-
can I change collation setting after installation?
-gugu(GuGu);
2003-1-19
(#986231@0)
-
似乎不行。不过你还是等资深专家的回答吧。
-lazycod(沧海一笑);
2003-1-19
(#986236@0)
-
can i change it incode?
-gugu(GuGu);
2003-1-19
(#986250@0)
-
好像也不行
-lazycod(沧海一笑);
2003-1-19
(#986259@0)
-
1.for SQL 2000, you may change collation after the installation.
2.for SQL 7 and SQL 6.5, you have to re-run the installation to change the collation.
-yangn(Raymond);
2003-1-19
(#986336@0)
-
thanks, I got it.
-elac(elac);
2003-1-19
(#986698@0)