sqlgrey-users

[Sqlgrey-users] Accent characters cause query failure.

[Philippe C. <sql...@pa...>]

	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?

-- 
   .----------.    ,----------== Peep ==----------,
  /  .-.  .-.  \   `-== (Philippe Chaintreuil) ==-`
 /   | |  | |   \   On The Other Side Of The Wall!
 \   `-'  `-'  _/      FidoNet Netmail Address:
 /\     .--.  / |             1:2613/118
 \ |   /  /  / /          InterNet  Address:
 / |  `--'  /\ \        pe...@pa...
  /`-------'  \ \  --PiCTuRe By aN uNKNoWN aSCii aRTiST--
     "We're just two lost souls swimming in a fish bowl..."

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