<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-2 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.23543"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT size=2 face=Arial>Maybe the problem arises because
DefaultDataPopulator uses the 'query' method</FONT></DIV>
<DIV><FONT size=2 face=Arial>instead of the 'pquery' call with bound parameters,
so actual data values get embedded</FONT></DIV>
<DIV><FONT size=2 face=Arial>into a query string and therefore SET NAMES utf8 is
required to make it work correctly.</FONT></DIV>
<DIV style="FONT: 10pt Tahoma"><FONT face=Arial></FONT><FONT
face=Arial></FONT><FONT face=Arial></FONT><FONT face=Arial></FONT> </DIV>
<DIV style="FONT: 10pt Tahoma"><FONT face=Arial>Most other queries for
inserting/updating data during normal workflow use pquery</FONT></DIV>
<DIV style="FONT: 10pt Tahoma"><FONT face=Arial>and bound parameters and
calling/omitting SET NAMES utf8 may have no impact there.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Another idea may be that during installation not
all default variables have correct</FONT></DIV>
<DIV><FONT size=2 face=Arial>values and SET NAMES utf8 is not called when it
should be, so UTF-8 characters</FONT></DIV>
<DIV><FONT size=2 face=Arial>get inserted into the database
incorrectly.</FONT></DIV>
<DIV style="FONT: 10pt Tahoma"><FONT face=Arial></FONT><FONT
face=Arial></FONT><BR></DIV>
<DIV style="FONT: 10pt Tahoma; BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=m.zygmuntowicz@onet.pl
href="mailto:m.zygmuntowicz@onet.pl">Zygmuntowicz Michal</A> </DIV>
<DIV><B>Sent:</B> Monday, December 16, 2013 12:41 PM</DIV>
<DIV><B>To:</B> <A title=vtigercrm-developers@lists.vtigercrm.com
href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</A>
</DIV>
<DIV><B>Subject:</B> [Vtigercrm-developers] Installation and non-ASCII
characters in thedefault data populator</DIV></DIV>
<DIV><FONT size=2 face=Arial></FONT><FONT size=2 face=Arial></FONT><BR></DIV>
<DIV><FONT size=2 face=Arial>Hello,</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>during Vtiger 6 installation Polish currency and
language names</FONT></DIV>
<DIV><FONT size=2 face=Arial>display non-ASCII characters incorrectly (I guess
the problem relates</FONT></DIV>
<DIV><FONT size=2 face=Arial>to other languages as well). I have reviewed the
ticket <A
title="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7784
Kliknij, trzymając wciśnięty klawisz CTRL, aby użyć łącza"
href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7784">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7784</A></FONT></DIV>
<DIV><FONT size=2 face=Arial>and added an approtiate comment.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The problem seems to be a missing call to SET NAMES
utf8</FONT></DIV>
<DIV><FONT size=2 face=Arial>while populating default data in the
modules/Users/DefaultDataPopulator.php file.</FONT></DIV>
<DIV><FONT size=2 face=Arial>I guess it should be called automatically, but it
does not happen.</FONT></DIV>
<DIV><FONT size=2 face=Arial>If I insert the call manually, the default data
gets populated correctly.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Maybe it is somehow related to mysql server
settings. My settings are:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Server characterset:
latin1<BR>Db characterset:
utf8<BR>Client characterset: utf8<BR>Conn.
characterset: utf8<BR></FONT></DIV>
<DIV><FONT size=2 face=Arial>I create a database by hand before starting
installation with the utf8 character set,</FONT></DIV>
<DIV><FONT size=2 face=Arial>but the default server character set is latin1 -
maybe this causes the problem</FONT></DIV>
<DIV><FONT size=2 face=Arial>and requires SET NAMES utf8.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards,</FONT></DIV>
<DIV><FONT size=2 face=Arial>Michal Zygmuntowicz</FONT></DIV>
<DIV><FONT size=2 face=Arial> </DIV></FONT>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.vtiger.com/</BODY></HTML>