Partially UTF 8 Database
Posted by: Santiago del Castillo
Date: April 20, 2006 09:24AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partially UTF 8 Database
3072
April 20, 2006 09:24AM
1783
April 25, 2006 03:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.