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

[Zygmuntowicz Michal]

Tested and confirmed to work. Thank you for the quick fix!


From: Prasad 
Sent: Tuesday, December 17, 2013 10:12 AM
To: vtigercrm-developers at lists.vtigercrm.com 
Subject: Re: [Vtigercrm-developers] Installation and non-ASCII characters in thedefault data populator


Fixed @13964 - During installation explicit setting was required on DB connection since default_charset was not initialized in config.inc.php to UTF-8. 

Regards,
Prasad



Connect with us on: Twitter I Facebook I Blog I Wiki I Forums I Website



On Mon, Dec 16, 2013 at 7:26 PM, Zygmuntowicz Michal <m.zygmuntowicz at onet.pl> wrote:

  Maybe the problem arises because DefaultDataPopulator uses the 'query' method
  instead of the 'pquery' call with bound parameters, so actual data values get embedded
  into a query string and therefore SET NAMES utf8 is required to make it work correctly.
  Â 
  Most other queries for inserting/updating data during normal workflow use pquery
  and bound parameters and calling/omitting SET NAMES utf8 may have no impact there.
  Â 
  Another idea may be that during installation not all default variables have correct
  values and SET NAMES utf8 is not called when it should be, so UTF-8 characters
  get inserted into the database incorrectly.


  From: Zygmuntowicz Michal 
  Sent: Monday, December 16, 2013 12:41 PM
  To: vtigercrm-developers at lists.vtigercrm.com 
  Subject: [Vtigercrm-developers] Installation and non-ASCII characters in thedefault data populator


  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/





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


_______________________________________________
http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20131217/5d5309f1/attachment-0001.html>