How to change the default charset of a MySQL table?

by

If you want to change the table default character set and all character columns to a new character set, use a statement like this: 

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

So query will be:

ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. How to convert an entire MySQL database characterset and collation to UTF-8?
  3. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  4. Change MySQL default character set to UTF-8 in my.cnf?
  5. How do I see what character set a MySQL database / table / column is?
  6. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  7. Troubleshooting “Illegal mix of collations” error in mysql
  8. How can I find non-ASCII characters in MySQL?
  9. UTF-8: General? Bin? Unicode?
  10. Save Data in Arabic in MySQL database
  11. How to change the CHARACTER SET (and COLLATION) throughout a database?
  12. How to change collation of database, table, column?
  13. What effects does using a binary collation have?
  14. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  15. Are column and table name case sensitive in MySQL?
  16. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  17. Fetching UTF-8 text from MySQL in R returns “????”
  18. How to fix double-encoded UTF8 characters (in an utf-8 table)
  19. Illegal mix of collations error in MySql
  20. What is the best MySQL collation for German language
  21. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  22. MySQL treats ÅÄÖ as AAO?
  23. MySQL distinction between e and é (e acute) – UNIQUE index
  24. MySQL Illegal mix of collations
  25. MySQL: Get character-set of database or table or column?
  26. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  27. Import data in MySQL from a CSV file using LOAD DATA INFILE
  28. mysql trigger stored trigger is already used by statement which invoked stored trigger
  29. What is the difference between the backtick and the square bracket in SQL statements?
  30. MySQL: Computed Column

Leave a Comment