Turkish character problem in SQL Server 2000
From: Aynur Demircan (Demircan_at_discussions.microsoft.com)
Date: 10/15/04
- Next message: alexcn: "Database Design - Urgent!"
- Previous message: John Bell: "RE: Tracking data changes"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 15 Oct 2004 00:35:04 -0700
Hi,
I'm trying to migrate a Sybase SQL Anywhere database to SQL server 2000. I
have a problem when I choose "Turkish_CI_AS" as the database collation: The
problem occurs when I query a table with a column named "CompID".
When I write "Select compid from Table1", SQL Server returns the error
"Column compid not found".
I get from that error that there's a mismatch between uppercase I and
lowercase I(which I use as i).
When I use lowercase I(not i) there's no error.
But my problem is, we have lots of programs written for querying the
database tables
which frequently use lowercase i instead of I.
When I change the collation to Latin1_General_CI_AS, the problem is solved
but then there comes a different problem:
This time, colums with type char(x) don't display the Turkish characters in
the rows correctly. (characters like 'Ç','Ş', 'ş''İ'(dotted uppercase I),'ü')
. To solve this problem, I change the collation of the column with the char
data type to Turkish_CI_AS but still the problem is not solved. (I think my
regional settings and default language settings are correct(Turkish).
I'll be really glad if someone can help me about the problem.
Thanks,
Aynur
- Next message: alexcn: "Database Design - Urgent!"
- Previous message: John Bell: "RE: Tracking data changes"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
