Thank you, I think we will stick to utf8 then.

Vince

On Wednesday, October 18, 2017 at 12:00:48 PM UTC-7, Christian Hammond 
wrote:
>
> Hi Vince,
>
> Right now, don't use utf8mb4 by itself. That *is* the right encoding to 
> use for proper Unicode support, yes, but additional settings need to be 
> enabled manually on your database (globally and per-table) in order for key 
> lengths to not be truncated (which will otherwise break things horribly). I 
> could provide this information if you wanted to be a guinea pig, but the 
> reality is that future upgrades won't be able to apply the settings on 
> newer tables just yet, so upgrades can still break the compatibility.
>
> I've done a lot of experimentation with this, and I'm hoping that by the 
> Review Board 4.0 timeframe that I can have built-in support, documentation, 
> and a conversion tool for properly enabling utf8mb4 and all related 
> settings as part of Review Board. I know exactly what needs to be done, 
> it's just a matter of doing it and having a lot of testing in place, which 
> we weren't able to do for 3.0.
>
> Christian
>
> On Wed, Oct 18, 2017 at 9:57 AM, Vince Thyng <[email protected] 
> <javascript:>> wrote:
>
>> Is anyone using utf8mb4?  We are looking at moving from latin1 to utf8.  
>> This article makes the case for using it over utf8, 
>> https://mathiasbynens.be/notes/mysql-utf8mb4 and am hoping someone in 
>> the community already has experience with it.  I figure we will need to 
>> look at the size of every text field to be sure that losing 25% of the max 
>> will not cut off any data, or else increase the size before switching to 
>> mb4.
>>
>> Thanks!
>>
>> Vince
>>
>> -- 
>> Supercharge your Review Board with Power Pack: 
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons: 
>> https://rbcommons.com/
>> Happy user? Let us know! https://www.reviewboard.org/users/
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "reviewboard" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Christian Hammond
> President/CEO of Beanbag <https://www.beanbaginc.com/>
> Makers of Review Board <https://www.reviewboard.org/>
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to