mysql encoding utf-8 not working

Question

I changed charset of database, tables and columns into UTF-8 :

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE collection CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE collection MODIFY title VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci;

And I inserted data into this table.

insert into collection (title) values ('Enfants et bébés');

Actually, data is inserted from a .sql file which is encoded in UTF-8 :

source collections.sql

The trouble is that the encoding fails :

select * from collection
+----+------------------------+
| id | title                  |
+----+------------------------+
| 17 | Enfants et BÃ©bÃ©s     |
+----+------------------------+

I don't understand what's wrong. Thank you for your help

hadf · Accepted Answer · 2017-09-08 16:15:20Z

1

I found the solution. The trouble cames from mysql client which is not in UTF-8 :

SET NAMES utf8

answered Sep 8, 2017 at 16:15

hadf

2822 gold badges6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql encoding utf-8 not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related