Jump to content
Sign in to follow this  
rhishi20

what is collation ?

Recommended Posts

i have read that when i want to store unicode characters then we have to use nvarchar as datatype and if we are storing regular type of characters then we can use varchar as datatype. i heard that collation is related with unicode characters but not knowing what is mean by collation? and how it is related with unicode characters ?

 

when i have done sp_help tablename

 

one of the column displays

 

collation

-----------

 

SQL_Latin1_General_CP1_CI_AS

 

so please tell me this means what ?

Edited by rhishi20

Share this post


Link to post
Share on other sites

Collation and character set mean the same thing. It is the way the characters are stored in a binary fashion. Different collations store characters differently. Unicode has a defined way on how characters get stored, so when you choose a unicode collation then that's how it stores the characters.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...