UTF-8 MySQL and PDF invoice problem SOLVED

[pera]

From one version to another I have had problems with utf8, utf8_general_ci, latin1_swedish_ci, etc. etc.

I converted my database to utf-8.

Maybe this will help someone:

 

1. in control panel / General Settings / Localisation / System Charset

UTF-8

 

2. In the configuration.php

 

$mysql_charset = "utf8";

 

3. This one is tricky. You have to go to phpmyadmin. Then look in every table!

The table can be utf8_general_ci but if you look at table structure and field, there I found some field with latin1_swedish_ci

changing them to utf8_general_ci solved my problem.

 

and for utf8 in pdf invoice you need to download:

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

 

 

more information with pictures:

 

http://winstart.com/template/section-blog/57-whmcs/250-whmsc-utf-8-solution-guide.html

 

hope this help someone!