MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: 4 byte emoji chars displayed as ?? when Japanese characters included
Posted by: Xing Zhang
Date: January 09, 2017 08:06PM

Please check whether your "Load data" statement used correct character set which makes sure your data is not damaged when loading into table. In this case, I think "LOAD DATA INFILE '/path/to/file' INTO TABLE XXX CHARACTER SET utf8mb4" will work.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
4 byte emoji chars displayed as ?? when Japanese characters included
2797
Stuart McClune
January 08, 2017 03:00PM
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
1011
Peter Brawley
January 08, 2017 04:19PM
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
1110
Stuart McClune
January 08, 2017 04:49PM
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
1042
Stuart McClune
January 08, 2017 05:31PM
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
891
Peter Brawley
January 08, 2017 08:12PM
Re: 4 byte emoji chars displayed as ?? when Japanese characters included
1067
Xing Zhang
January 09, 2017 08:06PM


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.