whmsc UTF-8 solution guide!

Last Updated on Thursday, 31 December 2009 19:29 Written by Pera Tudt Thursday, 31 December 2009 16:13

whmsc UTF-8 problem solution

Have been with utf8 problem Long time now... but thingk I get it right now!

First in the contro panel:

 

I the configuration.php last line

$mysql_charset = "utf8";

Have to mention that I changed the MySQL database to utf-8

and when I look in phpMyAdmin everything seen ok:

utf8_general_ci on every table

Still some characters did not display right.

I try to change the characters directly in phpMyAdmin and get error message:

-- Warning: #1366 Incorrect string value: '\xC4\x8D' for column 'title' at row 1

with closer look at the table I notice::::

When looking on table strukture Field Collation

That some field has latin1_swedish_ci

so I went trought every table and changed!

 

 

 At the table tblknowledgebase I had to change both field at the same time, did not work one by one, see next two pictures:

(have alredy changed so there is no latin1_swedish_ci ... but you get the point!)

 

 

 The last part  here was the tricky one.... Think this open new way of solution to many simular problem...

Next thing I have to solve is the PDF... there i get "?" without "" for serbian character č.

Hope this helped some one!

 

and for the pdf invoice you have to install unicod fonts....

http://www.whmcs.com/members/dl.php?type=d&id=37

 

must loging to download....

 

thats all for utf-8 and whmsc!!!

:-)