sql - strange behavior with Turkish language setting -

i have database collation arabic_ci_as

when have windows english language settings can do

select column table column= 'a'

and can do

select column table column= 'a'

i mean naming not case sensitive

in turkish windows

if of names not named in db raise error in windows application

i mean in turkish windows names must case sensitive

any thought explain , how solve such don't face 1 time again in language settings

the difference might in collation used.

depending on collation, code might case sensitive or case insensitive.

you can check server collation command:

select serverproperty('collation')

somwtimes, database collation may different, check command:

select databasepropertyex('databasename', 'collation')

for more info, see this article.

sql sql-server-2005 sql-server-2000

Kamlesh