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.
Subject
Views
Written By
Posted
can I use latin1 and utf8 at the same time?
3581
December 11, 2012 07:16AM
2202
December 22, 2012 03:36PM
1891
January 10, 2013 01:48AM
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.