Thank you for clarifying :) On Wed, Jun 4, 2014 at 5:20 AM, Claus Andersen <clan@wheel.dk> wrote:
On Wed, 28 May 2014, Joel White wrote:
Just a question. I want to attempt to use MySQL as the DB for
FreeSWITCH, many of the other systems use MySQL and I would like to keep the data in the same place.
The question is, what character set and collation should I use?
The FreeSWITCH site explicitly states to NOT use utf8
That is not correct. It states you should not use utf8_bin. You should be fine with utf8_general_ci AFAIK.
utf8_bin: compare strings by the binary value of each character in the string
utf8_general_ci: compare strings using general language rules and using case-insensitive comparisons
utf8_general_cs: compare strings using general language rules and using case-sensitive comparisons
For example, the following will evaluate at true with either of the UTF8_general collations, but not with the utf8_bin collation:
Ä = A Ö = O Ü = U
See http://dev.mysql.com/doc/refman/5.5/en/charset-binary-collations.html
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.
Kind Regards, Claus Andersen _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org