lua-resty-mysql icon indicating copy to clipboard operation
lua-resty-mysql copied to clipboard

Published 20 hours ago • verified publisher icon openresty

When i insert some emoji into mysql, they change to ???

Open iooly opened this issue 10 years ago • 2 comments

My server chatsert is utf8mb4, and also i query "set names 'utf8mb4'" after connect

iooly avatar Aug 02 '15 19:08 iooly

@iooly Recheck every link in your data flow (from web browser, to nginx, to mysql, to mysql database and tables, and backward) and ensure the same charset is used upon every link. Failures to ensure that can result in "???". I'm pretty sure this library works with multi-byte characters like UTF-8.

Mind you, MySQL is hairy in encoding settings and different layers may use different charsets. Please consult the your MySQL server's manuals for details on getting charsets right.

agentzh avatar Aug 04 '15 13:08 agentzh

thanks, i will check those carefully.

iooly avatar Aug 06 '15 18:08 iooly