Page 1 of 1

UTF8 and latin1 tables in mysql

Posted: Tue May 18, 2010 2:44 pm
by st3fanos
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

Re: UTF8 and latin1 tables in mysql

Posted: Wed May 19, 2010 4:53 am
by Benjamin
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

Posted: Wed May 19, 2010 12:48 pm
by st3fanos
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