can I use latin1 and utf8 at the same time?
Posted by: Greg K
Date: December 11, 2012 07:16AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
can I use latin1 and utf8 at the same time?
3581
December 11, 2012 07:16AM


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.