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
UTF8 and latin1 tables in mysql
Moderator: General Moderators
Re: UTF8 and latin1 tables in mysql
I've never experienced any issues with mixing collations. You could save a lot of time by setting the entire db to utf8_general. Just verify that the tables which already have a set collation are updated because I don't know off hand if they will be.
Re: UTF8 and latin1 tables in mysql
Thanks, I was thinking that too. I am still developing and the tables are empty still so I think it's the way to go.
Kind Regards
Stephen
Kind Regards
Stephen