[Vtigercrm-developers] Installation and non-ASCII characters in the default data populator

Zygmuntowicz Michal m.zygmuntowicz at onet.pl
Mon Dec 16 11:57:52 GMT 2013

Yes, changing the table is not enough for some reason. But if the installation script
populates the data correctly, everything displays fine in all views.

From: Jonathan Sardo 
Sent: Monday, December 16, 2013 12:49 PM
To: vtigercrm-developers at lists.vtigercrm.com 
Subject: Re: [Vtigercrm-developers] Installation and non-ASCII characters in the default data populator

Hello Michal, 

I have the same problem with euro (€) currency.
Even if I change manually the currency's symbol in the "vtiger_currency_info" table (column "currency_symbol"), the currency's symbol is not well displayed on every pages... 


Jonathan SARDO

Tél. 06 99 45 50 47

2013/12/16 Zygmuntowicz Michal <m.zygmuntowicz at onet.pl>


  during Vtiger 6 installation Polish currency and language names
  display non-ASCII characters incorrectly (I guess the problem relates
  to other languages as well). I have reviewed the ticket http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7784
  and added an approtiate comment.

  The problem seems to be a missing call to SET NAMES utf8
  while populating default data in the modules/Users/DefaultDataPopulator.php file.
  I guess it should be called automatically, but it does not happen.
  If I insert the call manually, the default data gets populated correctly.

  Maybe it is somehow related to mysql server settings. My settings are:

  Server characterset:    latin1
  Db     characterset:    utf8
  Client characterset:    utf8
  Conn.  characterset:    utf8

  I create a database by hand before starting installation with the utf8 character set,
  but the default server character set is latin1 - maybe this causes the problem
  and requires SET NAMES utf8.

  Michal Zygmuntowicz



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20131216/8949de12/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 4223 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20131216/8949de12/attachment-0001.png>

More information about the vtigercrm-developers mailing list