So I have a table that is 'utf8_general_ci' with the same fields.
I couldn't get any utf8 characters into it, they all showed as '????' , then I changed table to 'MyISAM' and now I can insert utf8 data from PhpMyAdmin (first time something like this happens).
But it still doesn't work from PHP side. When I insert 'āāā' it shows as '???', but the weird part is if I insert 'žžžēēē' it show as 'žžž???' so some utf8 characters work? PHP file is UTF-8
CREATE TABLE IF NOT EXISTS `company` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=5 ;
$dbConnection = mysql_connect("localhost","*****","*****");
mysql_query("SET NAMES 'utf8'", $dbConnection);
mysql_query("SET CHARACTER SET 'utf8'", $dbConnection);
mysql_select_db('cherrysystem', $dbConnection);
mysql_query("INSERT INTO `company` (`title`) VALUES ('āāčč')",$dbConnection);
RESOLVED
Ok, so problem in my case was that I had to set MySql ini file to use utf8. By default it was something else, I'm using Wamp server and it have always worked without extra configuring, but not in this case.
character-set-server=utf8
collation-server=utf8_general_ci