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 |
|
bobz_0585
Yak Posting Veteran
55 Posts |
 Posted - 2009-04-22 : 06:36:57
|
| this issue is killing me...yesterday i was working on my application it had a simple select statement but it wasn't working well because as it turns out my database is case sensitive..i researched the issue and found out that because my collation is case sensitive...so i created another database with the following collation:"SQL_Latin1_General_CP1256_CI_AS" which is case insensitive and i copied my data and recreated my application..it took me alot of time and when i was done i tested it and guess what!!! still case sensitive...for testing purposes i created a test table and queried it with deferent cases and it was insensitive..but when i query the first table...it is case sensitivei checked the collation of the table itself and it is SQL_Latin1_General_CP1256_CI_AS so what can be the issue... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-22 : 06:39:19
|
If the columns in tables were created with collation, that is the collation in use for columns.You can always make COLLATION conversions on-the-fly, seeSELECT *FROM Table1WHERE Col1 COLLATE SQL_Latin1_General_CP1256_CI_AS = 'SQLTeam'
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-04-22 : 06:51:49
|
| if u want to change that on database level then use ALTER DATASE, use COLLATE optionlike ALTER DATABASE MyDatabase COLLATE <desired collation>or jus do as PESO Sir.. told u at thr time fo query run...Thanks.....iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
|
|
|
case sensitivity