Re: [Sqlgrey-users] Accent characters cause query failure.

[Lionel B. <lio...@bo...>]

Philippe Chaintreuil wrote:
> 	I get errors like the following about once a week:
>
> Dec 15 19:51:51 hobbes sqlgrey: dbaccess: warning: couldn't do query:
> UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE
> sender_name = 'schuhböckoubut' AND sender_domain = 'rocketmail.com' AND
> src = '124.106.4.237': Illegal mix of collations
> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
> operation '=', reconnecting to DB
>
> 	You'll notice the 'ö' in the sender_name.  I used to get a different
> error (couldn't coerce?), and found a suggestion to do something to the
> sqlgrey database.  I think that's why I'm now getting the
> utf8_general_ci in the error now.
>
> 	Anyone have any suggestions as to what I can do to fix this?
>
>   

Hum, is your database configured to use UTF-8?

If so you can get such errors, as email adresses are sent from Postfix 
as pure ASCII which can (and does regularly) use invalid UTF-8 
sequences. You'll have to convert it to ASCII (latin-1 will do, it's 
fine when fed with ASCII data).

I should really add an entry related to non-ANSI characters (accentuated 
mainly) to the FAQ :-)

Lionel