MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again

Hi list, I've got a query coming out of sugarCRM that is generating this error: MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' I recently converted the entire database to utf8 - made sure all the connections are utf8

Re: zip code search within x miles

On 4/16/05, Scott Gifford <[EMAIL PROTECTED]> wrote: > Jeff Kolber <[EMAIL PROTECTED]> writes: > > > How are sites doing the search by zip and coming up with results within x > > miles? Is there some OSS zip code download that has been created for this? > >

Re: zip code search within x miles

ested, anyone have insights into doing with Canadian Zip Codes or otherwise optimizing a database of Canadian Zip Codes? Jeff Kolber http://www.ForSaleByOwner.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

innoDB alter table and locking issues

onfiguration setting that influences this locking? - what strategies do people use to alter live busy tables ? Thanks for any and all input! Jeff Kolber ps: we are using: mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686) -- MySQL General Mailing List For list archives: http://lists.mysql