MySQL Forums
Forum List  »  PHP

problem encoding mysql 5.6
Posted by: Firas BenK
Date: March 19, 2015 05:25AM

Hello,

I can't insert into my data base a special characters, for exemple when I insert the word "hôtel" I have in my base "h?tel". Only latin1 is supported but impossible with UTF8.

This is my configuration:

Version du serveur : 5.6.21 - MySQL Community Server (GPL)
Jeu de caractères du serveur : UTF-8 Unicode (utf8)
cpsrvd 11.44.3.1
Version du client de base de données : libmysql - 5.1.73
Extension PHP : mysqli
PhpMyadmin: 4.1.8

I have insert in my code, after INSERT INTO:
mysql_set_charset('utf8mb4');

In my MySQL configuration file (/etc/my.cnf):
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

My data base is in utf8mb4_unicode_ci

Options: ReplyQuote


Subject
Written By
Posted
problem encoding mysql 5.6
March 19, 2015 05:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.