Hi Olof,

can you tell me exactly what did you do to get it to run please? I changed
the laconica.sql to bin8_general_ci before perform it but it is still not
working for me. People search returns no any result everytime.

2009/3/1 Olof Tjerngren <[email protected]>

> 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,
>>>
>>>
>>>
>>
>>
>>
>>
>
>
> _______________________________________________
> Laconica-dev mailing list
> [email protected]
> http://mail.laconi.ca/mailman/listinfo/laconica-dev
>
> --
Serge
_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev

Reply via email to