<div dir="ltr">Thank you for clarifying :)<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 4, 2014 at 5:20 AM, Claus Andersen <span dir="ltr"><<a href="mailto:clan@wheel.dk" target="_blank">clan@wheel.dk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Wed, 28 May 2014, Joel White wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Just a question. I want to attempt to use MySQL as the DB for FreeSWITCH, many of the other systems use MySQL<br>
and I would like to keep the data in the same place.<br>
<br>
The question is, what character set and collation should I use?<br>
<br>
The FreeSWITCH site explicitly states to NOT use utf8<br>
</blockquote>
<br></div></div>
That is not correct. It states you should not use utf8_bin. You should be fine with utf8_general_ci AFAIK.<br>
<br>
utf8_bin: compare strings by the binary value of each character in the string<br>
<br>
utf8_general_ci: compare strings using general language rules and using case-insensitive comparisons<br>
<br>
utf8_general_cs: compare strings using general language rules and using case-sensitive comparisons<br>
<br>
For example, the following will evaluate at true with either of the UTF8_general collations, but not with the utf8_bin collation:<br>
<br>
Ä = A Ö = O Ü = U<br>
<br>
See <a href="http://dev.mysql.com/doc/refman/5.5/en/charset-binary-collations.html" target="_blank">http://dev.mysql.com/doc/<u></u>refman/5.5/en/charset-binary-<u></u>collations.html</a><br>
<br>
utf8_bin should be slightly faster and I do not know why it should not be used. My guess is that there might be a problem with case sensitivity and would hence be vary of _cs.<br>
<br>
Kind Regards,<br>
Claus Andersen<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>