Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ndl
Starting Member
4 Posts |
 Posted - 2008-03-06 : 16:13:56
|
| I am new to Stored Procedure, so I want to find out what is COLLATE Latin1_General_BIN means? For example:Declare @Var_Tbl Table(CUSTID INT NOT NULL,FIRSTNAME VARCHAR(20) COLLATE Latin1_General_BIN NOT NULL,CUSTOMER VARCHAR(9) COLLATE Latin1_General_BIN NOT NULL)Any helps would appreciated.NLD |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-06 : 16:18:11
|
It basically sets the reference language of the characters in the field, useful in the event you need to have multiple, or different than that of the default to the database.
Poor planning on your part does not constitute an emergency on my part.http://technet.microsoft.com/en-us/library/ms175194.aspxhttp://technet.microsoft.com/en-us/library/ms143508.aspx |
 |
|
|
absan4
Starting Member
1 Post |
Posted - 2008-07-03 : 14:04:37
|
| Basically in this case, you are creating columns that are case sensitivite. |
|
|
|
|
|
|
What's COLLATE Latin1_General_BIN?