[firstride]

Hello. I have a problem.
I imported to mysql some values:

AUTHid Password Credits Timestamp

The problem is: In import sql , i have at authid: "SWAT" , and another "swat" or "swatx"

And in the mysql , after imort , i think it see's them duplicate , and only one value it's imported , i think the firt , in this example , "SWAT" , and the rest are not imported.
So i wan't in database to be SWAT and swat and SwaT or swatx or wathever
Sorry for my english

How can i solve that ? Please help , i need this

[YamiKaitou]

What does this have to do with AMXX? Refer to your SQL Manual and check the keys and flags on the table

[Sylwester]

http://stackoverflow.com/questions/4...case-sensitive

[firstride]

Already id set on utf8_general_ci ....

Tamikaitou , in the .sma i have:

SQL_QueryAndIgnore(g_Sql,"CREATE TABLE IF NOT EXISTS `%s` (`auth` VARCHAR(36) NOT NULL, `password` VARCHAR(32) NOT NULL DEFAULT '', `amount` INT(10) NOT NULL DEFAULT 0, `timestamp` INT(10) NOT NULL DEFAULT 0, PRIMARY KEY (`auth`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;", g_vars[table]);

That's the table i have inserted , and the players are deleted if it's: KANE or KaNe

[Sylwester]

utf8_general_ci is case-insensitive. Change it to utf8_general_cs and try again...

[firstride]

I have only _ci , nothing with _cs at the end

[Clauu]

PHP Code:

SET NAMES utf8
and
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;