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

[socialboostdk]

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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160628/fc905f1b/attachment-0001.html>