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

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

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <https://blogs.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <https://discussions.vtiger.com>*I*
Website<https://www.vtiger.com/>


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 <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
>
> 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/20131217/3a4a9fb2/attachment.html>


More information about the vtigercrm-developers mailing list