Hi All. I'm creating a Users Table which contains a Password field that I wish to make case sensitive. By default the database I'm working on is Case Insensitive. I cannot access the server with a management tool so this has to be done through code. I know that I have to use the Collate keyword but I'm unsure of the correct syntax.
My create statement is as follows;
CREATE TABLE AppUsers(UserId smallint NOT NULL,UserName varchar(255),UserPword varchar(8))
CREATE TABLE AppUsers(UserId smallint NOT NULL,UserName varchar(255),UserPword varchar(8) collate sql_latin1_general_cp1_cs_as)
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Creating Table with Case Sensitive Column
Posted - 12/12/2012 : 07:15:11
