[Vtigercrm-developers] Installation and non-ASCII characters in thedefault data populator
prasad at vtiger.com
Tue Dec 17 09:12:07 GMT 2013
Fixed @13964 <http://trac.vtiger.com/cgi-bin/trac.cgi/changeset/13964> -
During installation explicit setting was required on DB connection since
default_charset was not initialized in config.inc.php to UTF-8.
*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
*I* Blog <https://blogs.vtiger.com/>* I*
*I *Forums <https://discussions.vtiger.com>*I*
On Mon, Dec 16, 2013 at 7:26 PM, Zygmuntowicz Michal <m.zygmuntowicz at onet.pl
> Maybe the problem arises because DefaultDataPopulator uses the 'query'
> 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
> 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
> get inserted into the database incorrectly.
> *From:* Zygmuntowicz Michal <m.zygmuntowicz at onet.pl>
> *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
> 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
> 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
> and requires SET NAMES utf8.
> Michal Zygmuntowicz
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the vtigercrm-developers