In our previous article have explained how we can find the collation of database with a simple SQL Script in SQLSERVER. Check the Collation. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. ALTER TABLE ITEMS CHANGE DESCRIPTION DESCRIPTION TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; Column definition syntax for CREATE TABLE and ALTER TABLE has optional clauses for specifying the column character set and collation: . The ALTER TABLE statement is also used to add and drop various constraints on an existing table. Here in this example, we set i.e alter collation all tables columns as Change Collation for all Tables columns: Here in this article will see how we can modify the collation of our database tables column. I would prefer to avoid mysqldump.

SQL ALTER TABLE Statement. col_name {CHAR | VARCHAR | TEXT} (col_length) [CHARACTER SET charset_name] [COLLATE collation_name] col_name {CHAR | VARCHAR | TEXT} (col_length) [CHARACTER SET charset_name] [COLLATE collation_name] The statement also changes the collation of all character columns. I have been using mysql version 5.5.41 and have run into an issue. So I searched for a solution and found this. Note that if you really did want to change the collation for just one column (I can't think why you might, but who knows) then this is the syntax to alter a TEXT column called DESCRIPTION in the ITEMS table to UTF-8, binary, non-null:. In MySQL … If you specify no COLLATE clause to indicate which collation to use, the statement uses default collation for the character set. To change the character set and collation of an existing column, use the CHARACTER SET and COLLATE clauses within the ALTER TABLE statement: ALTER TABLE Tasks MODIFY TaskName VARCHAR(255) CHARACTER SET hebrew COLLATE hebrew_general_ci NOT NULL; This changes the column’s character set to hebrew and the collation to hebrew_general_ci. I change the collation of a specific column in my table from latin1_swedish_ci to hebrew_bin, and this changes the data in that column. Update: Richard Bronosky showed me the way :-) The query I needed to execute in every table: This tip will take you through the steps required to change the column COLLATION of your tables from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1_CS_AS. Every “ character ” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. Column definition syntax for CREATE TABLE and ALTER TABLE has optional clauses for specifying the column character set and collation: . ALTER TABLE - ADD Column. For instance I inserted école in the field, and on conversion, I got ?cole. Solution Table Setup. I need to execute these statements in all tables for all columns. Every “ character ” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation.

alter table table_name charset=utf8; alter table table_name alter column column_name charset=utf8; Is it possible to automate this in any way inside MySQL? Let's first setup a couple of tables in order to walkthrough these steps required to update the column collation.