Character encoding hell: Converting MySQL latin1 to utf8 for use in Django - The Diigo Meta page

• 05 Jun 09
  

  fei dong
• 30 Mar 09
  

  Will Bolton

  character_encoding tutorials code mysql databases

• 28 Jan 09
  

  Gerald Reinhart

  django database encoding

  • Character encoding hell: Converting MySQL latin1 to utf8 for use in Django

  • alter table TABLE_NAME modify FIELD_NAME blob;
    alter database DATABASE_NAME charset=utf8;
    alter table TABLE_NAME modify FIELD_NAME varchar(255) character set utf8;
    

    This forces MySQL to convert the binary format into varchar using character set utf8.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.