[Vtigercrm-developers] Best practice mysql configuration for international characterset?

[Prasad]

I haven't tried utf8mb4

--
FB <http://www.facebook.com/vtiger> I Twit <http://twitter.com/vtigercrm> I
LIn <https://www.linkedin.com/company/1270573?trk=tyah> I Blog
<https://blogs.vtiger.com> I Website <https://www.vtiger.com/>

On Tue, Jun 28, 2016 at 2:23 PM, socialboostdk <socialboostdk at gmail.com>
wrote:

> Thank you - excellent.
>
> Would utf8mb4 cause any problems, or is that also usable?
>
> Cheers,
> Chris
>
> On 28 June 2016 at 10:43, Prasad <prasad at vtiger.com> wrote:
>
>> Vtiger CRM 6.x attempts to create database with utf8. This could also be
>> set default in MySQL configuration.
>>
>> --
>> FB <http://www.facebook.com/vtiger> I Twit <http://twitter.com/vtigercrm>
>>  I LIn <https://www.linkedin.com/company/1270573?trk=tyah> I Blog
>> <https://blogs.vtiger.com> I Website <https://www.vtiger.com/>
>>
>> On Tue, Jun 28, 2016 at 1:42 PM, socialboostdk <socialboostdk at gmail.com>
>> wrote:
>>
>>> Hi everyone,
>>>
>>> What is the best practice configuration for mySql for vTiger (6.4, while
>>> waiting for 6.5 ;-)), when we need different kinds of characters?
>>>
>>> Ie. both northeren europen øæåöä, german ßü, russian телефон, etc.
>>>
>>> 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.
>>>
>>> I've of course checked that the csv was exported in a way where it does
>>> contain the proper characters.
>>>
>>> Should it be "utf8_general_ci" or what?
>>>
>>> Thanks!
>>>
>>>
>>> :) Chris
>>>
>>> _______________________________________________
>>> 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/20160628/e82c1d4a/attachment.html>