[Guide] Solving Case sensitive in DB.

View previous topic View next topic Go down

[Guide] Solving Case sensitive in DB.

Post by  on 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).


Favourite Game : MuOnline
Registration date : 1969-12-31

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum