MS SQL Server 2005 - SQL Problem
-
Hi all, Can SQL Server 2005 handle non-case sensitive sql statements. i.e. A table with the fields (fieldOne - fieldTwo) has some values: fieldOne fieldTwo i insert L lenght c car I inject C construct l loose So if one would to do a sql statement on that table i.e: A bit of ASP: var x = Request.QueryString("variable"); Lets say the value of x was: l "SELECT fieldTwo FROM table WHERE fieldOne = '"+x+"'" The output would be: Lenght .... This is what is happening to me .. :confused::confused: Can anyone help.....
The only programmers that are better than C programmers are those who code in 1's and 0's..... :) :) Programm3r
-
Hi all, Can SQL Server 2005 handle non-case sensitive sql statements. i.e. A table with the fields (fieldOne - fieldTwo) has some values: fieldOne fieldTwo i insert L lenght c car I inject C construct l loose So if one would to do a sql statement on that table i.e: A bit of ASP: var x = Request.QueryString("variable"); Lets say the value of x was: l "SELECT fieldTwo FROM table WHERE fieldOne = '"+x+"'" The output would be: Lenght .... This is what is happening to me .. :confused::confused: Can anyone help.....
The only programmers that are better than C programmers are those who code in 1's and 0's..... :) :) Programm3r
you have to alter your collation settings, the default collation in sql server 2005 is latin1_general_CI_AS CI = case insensitve AS = Accent sensitive you might have to change it in to Case sensitive. do google on "SQL Server Collation" for more details. have fun. cheers
-
you have to alter your collation settings, the default collation in sql server 2005 is latin1_general_CI_AS CI = case insensitve AS = Accent sensitive you might have to change it in to Case sensitive. do google on "SQL Server Collation" for more details. have fun. cheers
Thank you very much ... :) Regards,
The only programmers that are better than C programmers are those who code in 1's and 0's..... :) :) Programm3r