Re: Character encodings issues with php, mysql, apache
Posted by:
Rick James
Date: April 02, 2009 08:36PM
I agree that this is confusing.
Plan A: Do nothing. This will avoid corrupting the database by having 4-byte and 2-byte representation for such characters, both in the same table. But it does not solve your original question.
Plan B: Your "replace" suggestion -- I don't know of a way to easily do that.
Plan C: mysqldump the data, then reimport it. But the tricky part is to know what settings (eg SET NAMES, or maybe the different components of that macro) to use in each step. You would need different settings, but I don't know what they need to be. Sorry.
One (or more) database at my work is in the same pickle. For now, I am doing A.
Subject
Views
Written By
Posted
9993
March 27, 2009 09:46AM
4320
March 28, 2009 04:04PM
4709
March 30, 2009 10:20AM
3767
March 30, 2009 01:10PM
3823
March 30, 2009 07:46PM
3992
March 31, 2009 07:57AM
5543
March 31, 2009 07:46PM
4114
April 01, 2009 02:47PM
Re: Character encodings issues with php, mysql, apache
3947
April 02, 2009 08:36PM
4132
April 06, 2009 12:04PM
8058
April 13, 2009 05:10PM
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.