Jump to content

Character name show ??? used chinese


汪利华

Recommended Posts

Posted

Hi,

When i create a character ,and i used chinese words with the name,it's not work well,but i saw it looks ok in console,and it show ??? in the database.

can you help me?thanks.

2.png.e9bf3c7e4bfab6d27a755ed81be3cde5.png:1.png.bddf95cdda5862361b895aa694121976.png

 

Posted

This is looking like an encoding issue, possibly at db level !
 

Can you check your character DB and the table characters and see what you settings are as highlighted below:

 

Untitled.png

Posted

Hi,antz.

I check the db character set,it's "latin1",then I change it to "utf-8",It works!

thank you very much!!!

ps:I suggest add the "DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" in the end of all create database sql at InstallDatabases.bat/InstallDatabases.sh.

like this:

%mysql%mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% -e "create database %wdb% DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";

 

Posted
14 hours ago, 汪利华 said:

Hi,antz.

I check the db character set,it's "latin1",then I change it to "utf-8",It works!

thank you very much!!!

ps:I suggest add the "DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" in the end of all create database sql at InstallDatabases.bat/InstallDatabases.sh.

like this:

%mysql%mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% -e "create database %wdb% DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci";

 

Thank you, this update makes sense !

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use