[wp-trac] Re: [WordPress Trac] #7683: character "é" converted to "é" after upgrade from 2.5.1 to 2.6.1

[WordPress Trac]

#7683: character "é" converted to "é" after upgrade from 2.5.1 to 2.6.1
---------------------+------------------------------------------------------
 Reporter:  aloon    |        Owner:  anonymous
     Type:  defect   |       Status:  new      
 Priority:  low      |    Milestone:  2.8      
Component:  General  |      Version:  2.6.1    
 Severity:  minor    |   Resolution:           
 Keywords:           |  
---------------------+------------------------------------------------------
Comment (by aloon):

 Thank you for your help, I tried following the instructions on that page
 on the Codex to convert the database to UTF8, but I'm rather disappointed
 now. First of all, step 3 and other steps take an huge amount of work, I
 have to execute the command for every column in the tables of my database
 if I understand correctly. I started the work and enter the queries in
 phpMyAdmin, but after converting a few columns succesfully, I receive the
 following error message when I'm trying to alter the user_nicename column
 in the wp_users table:

 SQL query:

 ALTER TABLE wp_users MODIFY user_nicename BLOB

 MySQL said: Documentation
 #1170 - BLOB/TEXT column 'user_nicename' used in key specification without
 a key length



 Are there any easy instructions and an easy solution for people like me,
 who aren't MySQL experts? The page on the Codex talks about conversion
 scripts and plugins, but one of them doesn't have a working link and the
 other one corrupts data according to the page.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/7683#comment:5>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software