bravo14 0 Posted June 30, 2015 Share Posted June 30, 2015 Hi I am trying to store multiple languages e.g. Russian and English in one table, the charset for the table is utf8_general_ci when I add the russian characters to the table they are displayed as ??????? My question is, is it possible to store the multiple character sets in the table and how do I do this? Link to post Share on other sites
cyberRobot 126 Posted June 30, 2015 Share Posted June 30, 2015 Where are you trying to display the database contents? Are you using a PHP script to read the information from the database and display it to the screen? Link to post Share on other sites
bravo14 0 Posted June 30, 2015 Author Share Posted June 30, 2015 Hi That is the plan, but in phantasm in it is showing as ??????? And on my page currently it shows as ?????? The page charaet is set to Utf-8 Link to post Share on other sites
cyberRobot 126 Posted June 30, 2015 Share Posted June 30, 2015 Hmm...perhaps the characters were lost when the information was saved to the database. Note that PHP, HTML, and the MySQL connection object all need to be set to UTF-8. Perhaps the following will help: http://forums.phpfreaks.com/topic/296667-strange-character-when-insert/?do=findComment&comment=1513303 Link to post Share on other sites
bravo14 0 Posted June 30, 2015 Author Share Posted June 30, 2015 Thanks for the reply, I am trying to add it straight to the database through phpmyadmin and mySQL Workbench, and both of them are storing it as ?????? Link to post Share on other sites
cyberRobot 126 Posted July 1, 2015 Share Posted July 1, 2015 Now you mentioned that the table is set to UTF-8. Are the columns where you're trying to save Russian characters set to utf8_general_ci also? Link to post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.