Click here to Skip to main content
14,391,964 members
Rate this:
Please Sign up or sign in to vote.
See more:
Mysql hosting on 000Webhosting.com and my requirement to insert Indian local languages like "Gujarati" and "English" therefore I have set database and table collation to "utf8_bin" as below

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;


and
ALTER TABLE articles MODIFY Posts VARCHAR(20) CHARACTER SET UTF8;


changed it as above but not works its shows data like "????" Why its not allowed me to store data in local language.

What I have tried:

I have searched on online and altered it as above but not working.
Posted
Comments
MadMyche 3-Dec-19 10:28am
   
How are you viewing the data? Is this client being used set to use this charset as well?
MAHESH WAGHELA 3-Dec-19 10:34am
   
yes it is altered by me and I have seen it collation changed but not allow to insert local language instead it shows like "????"
Gerry Schmitz 3-Dec-19 12:05pm
   
"Shows" is about "Fonts" - regardless of the characters.
MAHESH WAGHELA 4-Dec-19 0:19am
   
yest it is about Fonts. I have set character and collation to utf8_bin but result is "????"

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100