8.3.08

Collation in sql server

Its used to define and instruct compilers to recognize the query keywords.
Code Snippet

Create database VenkatDatabase collate Latin1_General_CS_AS_KS_WS

In the above code, i am trying to create a database with supporting language as latin.
It should support,
CS - Case sensitiveness
AS - Accent sensitiveness
KS - Kana sensitiveness
WS - Width sensitiveness
We can specify the insensitiveness using the CI,AI,DI,WI
Ex:
CI - Case insensitiveness

No comments:

Post a Comment