can I use latin1 and utf8 at the same time?

[Greg K]

hi
Currenty I've got latin1, but I'd like to set utf8 as default charset for all levels (server,db,table,session,client).
Please, let me know if having set this in my.ini in client and server sections (of course it applies only for new databases and tables) I can still use my old databases and tables in latin1 fashion.
Or, will it collide when quering the data. Then should I unify?
As for backuping, I'm performing offline backups (not mysqldump), so restoring shouldn't be an issue.
I wouldn't like to do it as I have a TB db and the convertion will be troublesome.

it seems like each schema is independent, having own db.opt setting's file.

so now the only thing I try to figure out id what the application/client should be aware of.

Can you see here any risks to jumble the database?



Edited 2 time(s). Last edit at 12/12/2012 01:57AM by Greg K.