UTF8 and latin1 tables in mysql
Posted: Tue May 18, 2010 2:44 pm
Hi,
I am creating a db where some data (i.e. names, salutation, keywords) needs to be in another language so I code this in UTF8.
However 95% of the database is URL's, email addresses, timestamps, numbers etc..
My question, should I just go with the whole DB in UTF8 or should I mix the table collation?
I started by mixing the tables but my thinking is towards changing the DB all to be in UTF8 to avoid possible issues with inserts etc..
What are your ideas on table collation mixing?
Kind Regards
Stephen
I am creating a db where some data (i.e. names, salutation, keywords) needs to be in another language so I code this in UTF8.
However 95% of the database is URL's, email addresses, timestamps, numbers etc..
My question, should I just go with the whole DB in UTF8 or should I mix the table collation?
I started by mixing the tables but my thinking is towards changing the DB all to be in UTF8 to avoid possible issues with inserts etc..
What are your ideas on table collation mixing?
Kind Regards
Stephen