latin1 tables?
23 views
Skip to first unread message
Uncle Cheese
Sep 7, 2012, 4:21:18 PM9/7/12
to silverst...@googlegroups.com
SS3 builds all my tables in latin1 encoding. How do I make it UTF-8? And will that garble all my existing data?
Marcus Dalgren
Sep 7, 2012, 5:15:53 PM9/7/12
to silverst...@googlegroups.com
If I remember correctly SS creates all the tables in the default encoding for the database or the table if they differ (latin1 is often the setting if you don't change it).
However all fields that really use the encoding (like text/varchar fields) get utf8 encoding. AFAIK the database/table encoding is just a default value that's used to set table/field encoding if it's omitted when the tables/fields are created and doesn't actually affect the data. So the answer to your second question is no, your data should not get garbled if you change the default encoding of the db or the tables.
Explanation is here for db: http://dev.mysql.com/doc/refman/5.0/en/charset-database.html
And here for tables: http://dev.mysql.com/doc/refman/5.0/en/charset-table.html
However all fields that really use the encoding (like text/varchar fields) get utf8 encoding. AFAIK the database/table encoding is just a default value that's used to set table/field encoding if it's omitted when the tables/fields are created and doesn't actually affect the data. So the answer to your second question is no, your data should not get garbled if you change the default encoding of the db or the tables.
Explanation is here for db: http://dev.mysql.com/doc/refman/5.0/en/charset-database.html
And here for tables: http://dev.mysql.com/doc/refman/5.0/en/charset-table.html
Reply all
Reply to author
Forward
0 new messages