bravo14 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? Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/ Share on other sites More sharing options...
cyberRobot 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? Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/#findComment-1515284 Share on other sites More sharing options...
bravo14 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 Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/#findComment-1515286 Share on other sites More sharing options...
cyberRobot 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 Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/#findComment-1515287 Share on other sites More sharing options...
bravo14 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 ?????? Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/#findComment-1515298 Share on other sites More sharing options...
cyberRobot 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? Quote Link to comment https://forums.phpfreaks.com/topic/297119-storing-multiple-languages-in-one-mysql-table/#findComment-1515357 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.