List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:December 2 2004 2:48pm
Subject:Re: Illegal mix of collations with 4.1.7
View as plain text  
Hello.

Use Perl, DBI :)


Frederic Wenzel <freeed@stripped> wrote:
> On Tue, 30 Nov 2004 19:24:05 +0200, Gleb Paharenko
> <gleb.paharenko@stripped> wrote:
>> The first impression is that you forgot to convert character
>> columns. See:
>> 
>>   http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
>>   http://dev.mysql.com/doc/mysql/en/Charset-conversion.html
> 
> Once the Character Sets are set up (everything is utf8 now on my
> installation), how can it be achieved to convert *ALL* columns in
> *ALL* tables to the same, new COLLATION value?
> 
> Changing them by hand would lead to admin's fun for, say, weeks ;)
> 
> Thanks in advance,
> Fred
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Illegal mix of collations with 4.1.7V. M. Brasseur30 Nov
  • Re: Illegal mix of collations with 4.1.7Santino30 Nov
    • Re: Illegal mix of collations with 4.1.7V. M. Brasseur30 Nov
  • Re: Illegal mix of collations with 4.1.7Gleb Paharenko1 Dec
    • Re: Illegal mix of collations with 4.1.7Frederic Wenzel2 Dec
      • Re: Illegal mix of collations with 4.1.7Gleb Paharenko3 Dec