[Guide] Solving Case sensitive in DB.

by Sun Dec 23, 2007 1:21 pm

Quote:

Warning: mssql_query(): message: Disallowed implicit conversion from
data type varchar to data type varbinary, table
'MuOnline.dbo.MEMB_INFO', column 'memb__pwd'. Use the CONVERT function
to run this query. (severity 16) in c:\appserv\www\modules\doreg.php on
line 196

Warning: mssql_query(): Query failed in c:\appserv\www\modules\doreg.php on line 196

Warning: mssql_query(): message: Invalid object name 'VI_CURR_INFO'.
(severity 16) in c:\appserv\www\modules\doreg.php on line 197

Warning: mssql_query(): Query failed in c:\appserv\www\modules\doreg.php on line 197
Your account has been created succesfully

With this shit, they can creat more than one account with differents sizes of words, for example: Joey, joey, jOey...

Just do it:

Go
in SQL Analyzer > Memb_INFO, with the right button click in Design
Table, so select the current line "memb____id". In collation you'll see
three points when you click there. So disable "Case Sensitive".

Couldnt understand?? So look:

Do the same with the Tables: AccountCharacter and VI_CURR_INFO (If Case Sensitive ON).