Partially UTF 8 Database

[Santiago del Castillo]

Hi, i'm moving a 1.5 gb database from latin1 to UTf-8 and i wanted to know (in order to reduce time) if mysql handles well 'mixing' tables in latin1 and utf8, i mean, if i change some tables to utf8 but leave the database in latin1, when i insert data into that table will freak out? the same question goes if i change some tables to utf8 and leave others in latin1 and i do `alter database <databasename> charset=utf8;` and i insert data into a latin1 table. I think it's pretty obvious that it will freak out and the data stored will not encode well, but i've hope that it will not, if not, would be ENORMOUSLY great :)

thanks in advance!
Santiago del Castillo.

P.S.: Sorry my english :$



Edited 1 time(s). Last edit at 04/20/2006 09:26AM by Santiago del Castillo.