AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Mysql import problem (uppercase and lowercase) (https://forums.alliedmods.net/showthread.php?t=220951)

firstride 07-16-2013 09:38

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

YamiKaitou 07-16-2013 09:42

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

Sylwester 07-16-2013 09:45

Re: Mysql import problem (uppercase and lowercase)
 
http://stackoverflow.com/questions/4...case-sensitive

firstride 07-16-2013 10:30

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

Sylwester 07-16-2013 10:53

Re: Mysql import problem (uppercase and lowercase)
 
utf8_general_ci is case-insensitive. Change it to utf8_general_cs and try again...

firstride 07-16-2013 12:13

Re: Mysql import problem (uppercase and lowercase)
 
I have only _ci , nothing with _cs at the end

Clauu 07-16-2013 14:43

Re: Mysql import problem (uppercase and lowercase)
 
PHP Code:

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



All times are GMT -4. The time now is 06:28.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.