strange behavior with Turkish language setting

Question

I have database with Collation Arabic_CI_AS

when I have windows with English settings I can do

select Column from Table where Column= 'A'

and can do

select column from table where column= 'a'

I mean the naming is not case sensitive

In Turkish windows

if any of the names not as named in the DB it raise error in my windows application

I mean that in Turkish windows the names must be case sensitive

any idea to explain that and how to solve it such that I don't face it again in any language settings

Answer 1

The difference might be in the collation used.

Depending on the collation, the code might be case sensitive or case insensitive.

You can check server collation with this command:

SELECT SERVERPROPERTY('Collation')

Somwtimes, database collation may be different, check it with this command:

SELECT DATABASEPROPERTYEX('DatabaseName', 'Collation')

---

For more info, see THIS article.