Change Vtiger default language Character set

Hi,

I am testing vtiger and is quite satify with it. But I found Vtiger is set the default Language character set to Latin-1. It is not compatible to display Traditional Chinese character which we use in Taiwan. I could not find at the setting section in Vtiger to change the setting. I surf the net and found I can modify the php file by change $default_charset parameter, in config.inc.php file, by correct charset (UTF-8, ...)

Since I am quite new to Linux. So, My question is, How can I modify the config.inc.php. I need to access Via SSH? What command can I use to edit the config.inc.php? And what is the location/directory of config.inc.php?

Looking for your reply. Thanks in advance!!

Allen Chou

Change Vtiger default language Character set

Actually, improving internationalization on all of the applications we bundle at JumpBox is one of our standing goals. If you can wait a week or so, I will see that our VTiger gets updated correctly.

Also, could yo provide any references you may have handy on making these changes so we can verify what we do solves your specific issue?

Austin

Change Vtiger default language Character set

Hi Austin,

Sure, I can wait for you to update this jumpbox. You can check the jumpbox manage page and check Backup database. It will shows the charactor set is Latin-1. And you can check http://wiki.vtiger.com/index.php/Developers_How_To's...
in The middle of article.
How to change the char set for the tables in the MySQL database to CP1251
You must change $default_charset parameter, in config.inc.php file, by correct charset (UTF-8, ...)

Pleaswe let me know once you have this fixed.

Thanks,

Allen Chou

Still could not make all the display correct

Hi Austin,

I have changed config.inc.php to charset UTF-8. After that, some field could display chinese. Some field still could not display correctly. Instead, It display chinese character as: ???.

It looks the version in your jumpbox is v-tiger 5.04. When will you have 5.10 release?

Thanks,

Allen Chou

Change Vtiger default language Character set

Yeah, its not as simple as changing a configuration file. The database is not correctly configured to store UTF-8 data. The 5.1.0 Vtiger JumpBox is built it just needs to go through our QA process. It should be coming out next week unless our QA uncovers something broken in the application. Thank you for posting, I will make sure that chinese characters get tested.

Austin

Change Vtiger default language Character set

Hi Austin,

Thanks for your respond. Please help me to confirm if the new version 5.10's database setup will be configure to UTF-8. I am not a IT professional. So it will be huge of problem if I need to deal with Database setup. That why I try to choose Jumpbox.

Thanks,

Allen

Change Vtiger default language Character set

As I said in my previous reply. I will make sure that the chinese characters work correctly in this upcoming release.

Austin

PDF Export

Hi Austin,

It looks most of the functions work with Chinese characters now. But when I create a quotation and export as PDF. The PDF file could not display Chinese. Any solution?

Thanks,

Allen