Community Member Profile

Recent Blog Comments By Dimitar G.

• SQL Server Text Matching Is Case INSENSITIVE

  Posted on May 23, 2007 at 3:55 PM

  By default SQL Server 2000 (and 2005) installs with a case insensitive collation. It's the least problematic anyway but the most restricted in order of dev options like case sensitiveness, alphabetic order, etc. So I guess when installed your RDBS you left it with its default options. Chanc... read more »

• SQL Server Text Matching Is Case INSENSITIVE

  Posted on May 23, 2007 at 2:27 PM

  You might need to change the collation of the database (not reliable in SQL Server 2000) or reinstall SQL Server 2000 with a case sensitive collation. Take a look at this link: http://expertan... read more »