sql server - What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do? -
i have sql query create database in sqlserver given below:
create database yourdb on ( name = 'yourdb_dat', filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\yourdbdat.mdf', size = 25mb, maxsize = 1500mb, filegrowth = 10mb ) log on ( name = 'yourdb_log', filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\yourdblog.ldf', size = 7mb, maxsize = 375mb, filegrowth = 10mb ) collate sql_latin1_general_cp1_ci_as; go
it runs fine.
while rest of sql clear quite confused functionality of collate sql_latin1_general_cp1_ci_as
.
can explain me? also, know if creating database in way best practice?
it sets how database server sorts. in case:
sql_latin1_general_cp1_ci_as
breaks interesting parts:
latin1
makes server treat strings using charset latin 1, asciicp1
stands code page 1252ci
case insensitive comparisons 'abc' equal 'abc'as
accent sensitive, 'ΓΌ' not equal 'u'
Comments
Post a Comment