Jbro Posted January 12, 2012 Share Posted January 12, 2012 Hi No I am talking to EhsanCH OK but I think you need to go to phpmyadmin in in ticket tables see for real your characters have changed 0 Quote Link to comment Share on other sites More sharing options...
EhsanCh Posted January 19, 2012 Share Posted January 19, 2012 are you sure you did this steps : ? -save file as utf8 with signator encoding. -Make sure the following is included in your configuration.php file after convert $mysql_charset = 'utf8'; 0 Quote Link to comment Share on other sites More sharing options...
Jbro Posted January 19, 2012 Share Posted January 19, 2012 Please go to your phpmyadmin and view your ticket tables and you will see the characters are not correct. Your DB is not utf8 YOU ARE Wrong. 0 Quote Link to comment Share on other sites More sharing options...
abdofikry Posted March 27, 2012 Share Posted March 27, 2012 my database is in latin1 but i have some content in tickets and other tables already in utf8 and i converted like you said . the result is that tickets data that was already in utf8 was converted to utf8 so it got corrupted and became unreadable . how can we fix that ? is there a way of preserving the aleady utf8 data during the convertion ? or a way to fix the corrupted data after convertion ?? 0 Quote Link to comment Share on other sites More sharing options...
rabia123 Posted May 16, 2012 Share Posted May 16, 2012 Go to the following this is the step by step tutorials: docs.moodle.org/22/en/Converting_your_MySQL_database_to_UTF8 0 Quote Link to comment Share on other sites More sharing options...
nasos75 Posted March 19, 2013 Share Posted March 19, 2013 Everything worked like a charm, thank you! 0 Quote Link to comment Share on other sites More sharing options...
mirage2000 Posted May 2, 2013 Share Posted May 2, 2013 I am a newbie I just want to know exact use of converting database to UTF8. 0 Quote Link to comment Share on other sites More sharing options...
And then there was one les Posted May 18, 2013 Share Posted May 18, 2013 it is a charset thats all, it helps with the different languages. if you used iso-8859-1 rather than the standard in whmcs of utf-8 then any character that is not covered in the iso-8859-1 would not show properly in the web browser. this goes for any. If your database is utf-8 and you change the system to iso-8859-1 then some character wont display until you update them in the database. 0 Quote Link to comment Share on other sites More sharing options...
93till Posted June 22, 2013 Share Posted June 22, 2013 Thanks, works like a charm. 0 Quote Link to comment 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.