Thanks!If anyone wants it, I still have the script I generated to switch all columns over to utf8_general_ci. Sadly it drops all comments in the database so it's not good general fix.
MvH, [email protected] wrote:
This is a known bug. the collation should be utf8_general_ci. Just waiting for implementation :) http://laconi.ca/trac/ticket/776 On Fri, 27 Feb 2009 10:44:40 +0100 Olof Tjerngren <[email protected]> wrote:Hi, I had some problems querying the database, some email matches failed and the people search never returning any results for me. Then I noticed that the collation was utf8_bin which is case sensitive, so I switched to utf8_unicode_ci and now my email searches works and the fulltext people search started working as well. Is there some part of Laconica that depends on strings being stored with utf8_bin or is this a safe change to make? MvH,
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
