[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..."