That is not correct. It states you should not use utf8_bin. You should be fine with utf8_general_ci AFAIK.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
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