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

[Zygmuntowicz Michal]

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... 




Cordialement,


Jonathan SARDO


Tél. 06 99 45 50 47



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

  Hello,

  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.

  Regards,
  Michal Zygmuntowicz



  _______________________________________________
  http://www.vtiger.com/





--------------------------------------------------------------------------------


_______________________________________________
http://www.vtiger.com/
-------------- 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>