[turba] Mysql Turba char set problem

[Jan Schneider]

Zitat von Brock Palen <brockp at michiganlivestock.com>:

>
> On Aug 22, 2006, at 9:21 AM, Jan Schneider wrote:
>
>> Keep discussions on the list.
>>
>> Zitat von Brock Palen <brockp at michiganlivestock.com>:
>>
>>>
>>> On Aug 22, 2006, at 4:39 AM, Jan Schneider wrote:
>>>
>>>> Zitat von Brock Palen <brockp at michiganlivestock.com>:
>>>>
>>>>> I am getting the following in my horde-log.   My setup is as follows
>>>>>
>>>>> 5.1.4-pl4-gentoo
>>>>> apache2-2.0.58
>>>>> mysql-4.1.21
>>>>>
>>>>> Bellow is the full error message and the debug query that causes  
>>>>> the problem.
>>>>>
>>>>> Basicly the message is:
>>>>> Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and  
>>>>> (utf8_general_ci,COERCIBLE) for operation 'like'
>>>>>
>>>>> The value from conf.php
>>>>> $conf['sql']['charset'] = 'iso-8859-1';
>>>>>
>>>>> Which is the latin1 char set right?  I have never had to dig to deep
>>>>
>>>> Correct.
>>>>
>>>>> into sets before so i'm in the dark here.  Any insight would be helpful.
>>>>
>>>> What is the charset of your turba_objects table?
>>>
>>> It is cp12512 West European.
>>> The Collation is latin1_swedish_ci
>>> The table type in InnoDB.
>>
>> Is there anything special about the string you are searching for,  
>> or is this happening with any searches?
>
> Its having IMP automatically expand a address in the To: CC: or BCC;  
> lines of a new message.  For example i have  
> greg at michiganlivestock.com in my turba book.  I type in greg in to,  
> when i move out IMP tries to expand the address, i see the error in  
> the log, and IMP says it could not be expanded.
>
> General searching in the address-book does not cause this problem.   
> As far as i can tell.

Well, I'm out of ideas then.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/