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:

  1. latin1 makes server treat strings using charset latin 1, ascii
  2. cp1 stands code page 1252
  3. ci case insensitive comparisons 'abc' equal 'abc'
  4. as accent sensitive, 'ΓΌ' not equal 'u'

Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -