Mysql import problem (uppercase and lowercase)
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 |
Re: Mysql import problem (uppercase and lowercase)
What does this have to do with AMXX? Refer to your SQL Manual and check the keys and flags on the table
|
Re: Mysql import problem (uppercase and lowercase)
|
Re: Mysql import problem (uppercase and lowercase)
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 |
Re: Mysql import problem (uppercase and lowercase)
utf8_general_ci is case-insensitive. Change it to utf8_general_cs and try again...
|
Re: Mysql import problem (uppercase and lowercase)
I have only _ci , nothing with _cs at the end
|
Re: Mysql import problem (uppercase and lowercase)
PHP Code:
|
| All times are GMT -4. The time now is 06:28. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.