[Fernado Samuel]

Removed

[[KHK]Khalid]

Show the code where you check whether a player is registered or not (by name).

[ReneG]

That is why you should use an auto increment id for each user, two users will never have the same id, which will avoid this problem. It's more efficient this way.

If you're lazy to change your whole system, you can use the BINARY keyword in your query.

example

Код:

SELECT `username` FROM `users` WHERE BINARY `username` = 'Fernado'

or, you could just try changing the language collation to latin_gener_cs.

http://stackoverflow.com/questions/5...rison-on-mysql

[[MG]Dimi]

Thing is that MySQL isn't case sensitive so it will select FERNARDO, fernardo, FeRnArDo etc.

Read http://dev.mysql.com/doc/refman/5.0/...nsitivity.html

[Fernado Samuel]

Removed

[ReneG]

Quote:

Originally Posted by Fernado Samuel How to add BINARY to this code?

Did you read the query example at all?

pawn Код:

format(Query,sizeof(Query),"SELECT `user` FROM `playerdata` WHERE BINARY `user` = '%s' LIMIT 1;",pname);

[Vince]

You don't need to change anything in the queries. Just set the table's collation setting to latin1_general_cs. It doesn't really matter which setting you choose, as long as it has the _cs at the end (which stands for Case Sensitivity).