Mysql - does not save proper encoding

Asked Apr 25 '16 at 16:44

Active Apr 25 '16 at 16:44

Viewed 14 times

So I've been having this problem for a while. The problem is, I can't save an username to MySQL field. Correct username: Vėdarėlis

Field result: VÄ—darÄ—lis

As you can see below, my collation is set to utf8

And I'm pretty sure the PHP itself is working fine, because in the general mysql log, I have this line:

168308 Query    UPDATE users_steam SET name='Vėdarėlis', ......rest of the query....

So how do I properly set user name with proper encoding? Thanks

asked Apr 25 '16 at 16:44

Ned

1

Run this query before inserting `SET NAMES UTF8` – Mihai Apr 25 '16 at 16:48
Can I place it in the same query as the UPDATE? – Ned Apr 25 '16 at 16:48
No,but you only need to run it once unless you restart the server or edit you mysql config to always use utf8 connection – Mihai Apr 25 '16 at 16:49

0 Answers0