June 26, 2003 at 6:33 pm
Hi all, I got this issue and wonder if anyone knows about it.
As my purpose is to have the indexing as case sensitive, therefore when I installed SQL Server 2000, I chose "Windows Locale Collation" with case-sensitive and accent-sensitive, no binary. The indexing turned out good. However, this case-sensitivity effects on the tables as well. For example, I can create 2 tables "test" and "TEST" which is what I do not want. Is there any way that I can configure the system so that the case-sensitivity is only on the indexing but not the tables?
Cheers
June 27, 2003 at 4:28 am
How about keeping the DB Case-Insensitive but collate all your tables (when creating) into your case sensitive version?
/Hans
June 29, 2003 at 2:34 pm
Have a look at : Making the most of SQL Server 2000 collations at http://www.itworld.com/AppDev/136/ITW3856/pfindex.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply