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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-11-12 : 10:55:38
|
| Hi,I migrated SQL2000 to SQL2005. Some of query is not running due to CASE SENSETIVE. The query which works in SQL2000 is not working in SQL2005 Like select * from emp where empname like '%DS%' -Working fine in sql2000select * from emp where empname like '%DS%' -Working fine in sql2005Showing diffrent result set Is there any way I can turn off CASE SENSETIVITY in SQL2005? OR Is there any way I can configure SQL2005 sql compatable with SQL2000?Please advice.Thanks- |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-12 : 11:05:42
|
| yup. use a case sensitive collation for that. see belowhttp://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/ |
 |
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-11-12 : 14:48:51
|
| Can I change Collation of the SQL Server master database in SQL2005? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-12 : 23:09:06
|
quote:
Originally posted by sqlserverdbam
Can I change Collation of the SQL Server master database in SQL2005?
no need to change collation. just cast it different collation using COLLATE as shown in link |
|
|
|
|
|
|
CASE SENSETIVE