UTF8 and latin1 tables in mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
st3fanos
Forum Newbie
Posts: 12
Joined: Tue Apr 13, 2010 1:30 am

UTF8 and latin1 tables in mysql

Post 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
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: UTF8 and latin1 tables in mysql

Post 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.
st3fanos
Forum Newbie
Posts: 12
Joined: Tue Apr 13, 2010 1:30 am

Re: UTF8 and latin1 tables in mysql

Post 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
Post Reply