COLLATION: Chinese_PRC : Case Sensitive

Hi,

I created a database with Chinese_PRC_BIN collation.. I created tables with varchar datatype columns. For column name, It shows database default' as collation name.. If I click on the 'database default', It shows Windows collation as 'CHINESE_PRC' and Binary Sort.. Now, my problem is, the table and column becomes case-sensitive.. (ie.. If I key in, "Select * from test", it shows the list.. But "Select * from Test" is not giving up the list.). How to make table columns & table names case in-sensitive...?

Hi,
I got this help for sql collation name. You must select a collation with tail _AI_CI.

SQL Collation Name
A single string that specifies the collation name for a SQL collation.

Syntax
< SQL_collation_name > :: =

SQL_SortRules[_Pref]_CPCodepage_<ComparisonStyle>
<ComparisonStyle> ::=
_CaseSensitivity_AccentSensitivity | _BIN

Arguments
SortRules

A string identifying the alphabet or language whose sorting rules are applied when dictionary sorting is specified. Examples are Latin1_General or Polish.

Pref

Specifies uppercase preference.

Codepage

Specifies a one to four digit number identifying the code page used by the collation. CP1 specifies code page 1252, for all other code pages the complete code page number is specified. For example, CP1251 specifies code page 1251 and CP850 specifies code page 850.

CaseSensitivity

CI specifies case-insensitive, CS specifies case-sensitive.

AccentSensitivity

AI specifies accent-insensitive, AS specifies accent-sensitive.

BIN

Specifies the binary sort order is to be used.