<div dir="ltr"><div class="gmail_extra"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Hi, socialboostdk!</div><div dir="ltr"><br></div><div>Here is my translation of the installation manual for russian vTiger fork, applicable to opensource vTigerCRM as well</div><div><br></div><div dir="ltr"><p lang="ru-RU" style="margin:0px 0px 20px;padding:0px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;color:rgb(85,85,85);font-family:Arial,Tahoma,Verdana,sans-serif;line-height:20.4px;background-image:initial;background-repeat:initial">In MySQL settings you should uses UTF8 as default character set. To set if create file /etc/mysql/conf.d/utf8.cnf with following (for MySQL v 5.5 and above default-character-set not necessary):</p><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">[mysqld]</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">collation_server=utf8_general_ci</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">character_set_server=utf8</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">default-character-set=utf8</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">init_connect='SET collation_connection = utf8_general_ci'</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">init_connect='SET NAMES utf8'</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">[mysql]</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent">default-character-set = utf8</span></pre><p lang="ru-RU" style="margin:0px 0px 20px;padding:0px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;color:rgb(85,85,85);font-family:Arial,Tahoma,Verdana,sans-serif;line-height:20.4px;background-image:initial;background-repeat:initial">Also you should configure locales for <b>correct import handling.</b> To use Cyrillic characters you should have those locales : CP1251, UTF-8 and ISO-8859-1. Check existing and install if needed (strict corresponding for the character set and the locale are important):</p><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># locale -a</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># localedef -i ru_RU -f CP1251 CP1251</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># localedef -i ru_RU -f UTF-8 UTF-8</span></pre><pre lang="ru-RU" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># localedef -i en_US -f ISO-8859-1 ISO-8859-1</span></pre><p lang="ru-RU" style="margin:0px 0px 20px;padding:0px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;color:rgb(85,85,85);font-family:Arial,Tahoma,Verdana,sans-serif;line-height:20.4px;background-image:initial;background-repeat:initial"> </p><p lang="ru-RU" style="margin:0px 0px 20px;padding:0px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;color:rgb(85,85,85);font-family:Arial,Tahoma,Verdana,sans-serif;line-height:20.4px;background-image:initial;background-repeat:initial">Restart Mysql and Apache:</p><pre lang="en-US" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># /etc/init.d/mysql restart</span></pre><pre lang="en-US" style="margin-top:0px;margin-bottom:0px;padding:15px;border:0px;outline:0px;font-size:12px;vertical-align:baseline;border-radius:3px;color:rgb(85,85,85);line-height:20.4px;background:rgb(244,244,244)"><span style="margin:0px;padding:0px;border:0px;outline:0px;vertical-align:baseline;font-family:"Courier New",monospace;background:transparent"># /etc/init.d/apache2 restart</span></pre><div></div></div></div></div><div class="gmail_extra"><br></div><div class="gmail_extra">....next steps in install manual...</div><div class="gmail_extra"><br></div><div class="gmail_extra">Hope this helps!</div><div class="gmail_extra">If you need help with Russian stuff, you can write me directly.</div><div class="gmail_extra"><br></div><div class="gmail_extra">--</div><div class="gmail_extra">PINstudio</div><div class="gmail_extra">Oleg Antonov</div><div class="gmail_extra">Saint Petersburg, Russia<br></div><div class="gmail_extra"><br></div><br><div class="gmail_quote">2016-06-28 14:59 GMT+03:00 Prasad <span dir="ltr"><<a href="mailto:prasad@vtiger.com" target="_blank">prasad@vtiger.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">I haven't tried utf8mb4</div><div class="gmail_extra"><br clear="all"><div><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">--</div><div dir="ltr"><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><a href="http://www.facebook.com/vtiger" style="color:rgb(0,0,204)" target="_blank">FB</a> I </span><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twit</a> I <a href="https://www.linkedin.com/company/1270573?trk=tyah" style="color:rgb(0,0,204)" target="_blank">LIn</a> I <a href="https://blogs.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Blog</a> I <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Tue, Jun 28, 2016 at 2:23 PM, socialboostdk <span dir="ltr"><<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr">Thank you - excellent.<div><br></div><div>Would utf8mb4 cause any problems, or is that also usable?</div><div><br></div><div>Cheers,</div><div>Chris</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On 28 June 2016 at 10:43, Prasad <span dir="ltr"><<a href="mailto:prasad@vtiger.com" target="_blank">prasad@vtiger.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div><div><div dir="ltr">Vtiger CRM 6.x attempts to create database with utf8. This could also be set default in MySQL configuration.</div><div class="gmail_extra"><br clear="all"><div><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">--</div><div dir="ltr"><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><a href="http://www.facebook.com/vtiger" style="color:rgb(0,0,204)" target="_blank">FB</a> I </span><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twit</a> I <a href="https://www.linkedin.com/company/1270573?trk=tyah" style="color:rgb(0,0,204)" target="_blank">LIn</a> I <a href="https://blogs.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Blog</a> I <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote"><div><div>On Tue, Jun 28, 2016 at 1:42 PM, socialboostdk <span dir="ltr"><<a href="mailto:socialboostdk@gmail.com" target="_blank">socialboostdk@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div><div><div dir="ltr">Hi everyone,<br><br><div>What is the best practice configuration for mySql for vTiger (6.4, while waiting for 6.5 ;-)), when we need different kinds of characters? </div><div><br></div><div>Ie. both northeren europen øæåöä, german ßü, russian телефон, etc.</div><div><br></div><div>I can see that the current db is latin1_swedish_ci which was good with the northern european characters, but fails with the russian ones upon CSV import, where characters are converted into "?????" instead. </div><div><br></div><div>I've of course checked that the csv was exported in a way where it does contain the proper characters.</div><div><br></div><div>Should it be "utf8_general_ci" or what?<br><br></div><div>Thanks!<br></div><div><br></div><div><br></div><div>:) Chris</div></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div></div>