utf8 charset for MySQL and SugarCRM 4.2

[bogo123]

Hi,
I have got installed SugarCRM with MySQL (database encoding latin1). It works ok.
I would like to change database encoding to utf8. I have changed that encoding, in database I store polish fonts ( ąśół ), but in SugarCRM I can see only "???". If I add new record in SugarCRM, I will have "???" in database (but the same characters will be displayed in SugarCRM correctly). In browser pages are displaying in utf-8.

I would like add new records directly to MySQL database in UTF-8. Is it possible to set utf8 encoding in database for SugarCRM 4.2? What should I change in settings?

I have changed charset to utf-8 in config.php.

» Operating system (Debian)
» Sugar Suite version (4.2.0a)
» Webserver type and version (Apache 2)
» PHP version (5.1.6-1)
» MySQL server version (5.0.24a)

Thanks,
Marcin

[ruchida]

Hi

If you already set the default charset and collation of the database and tables to utf-8, you may only need to change a collation of a connection.
Try adding following lines in my.cnf and restart mysqld.

 [client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
init-connect=SET NAMES utf8 
  

If you still have latin1 conversion, you may need to add the line below in the mysqld section in my.cnf.

 skip-character-set-client-handshake 
  

[bogo123]

Thanks a lot!

It works perfectly now!

Marcin