Re: [Sqlgrey-users] Sqlgrey-users Digest, Vol 14, Issue 1

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

sql...@li... wrote:
 > 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



 > Date: Tue, 18 Dec 2007 23:36:43 +0100

	Wow.  Digest subscription to this list is *slow*.  I just got your 
response today March 28th, 2008!  I had almost forgotten I wrote that 
original e-mail.

	List owner: You might want to turn on mailman's "digest_send_periodic" 
option (on the Admin->Digest Options page of the web interface).

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

	I think it is.  I'm using MySQL, and I'm not that well versed in it's 
deep inner-workings.  Probably about a year ago, I read something that 
said I should get that utf8_general_ci,COERCIBLE in there.  I did that 
and it obviously didn't seem to do much.

 > 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  :-)

	I second the FAQ suggestion on this front -- it should also probably 
have the answer to my next question as well:

	Ummm...  How do I fix this in MySQL?

	It should also probably get added to the INSTALL instructions as well.


	Sorry if this has all been addressed since Lionel replied back in December.

-- 
    .----------.    ,----------== Peep ==----------,
   /  .-.  .-.  \   `-== (Philippe Chaintreuil) ==-`
  /   | |  | |   \
  \   `-'  `-'  _/      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..."