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
10036
March 27, 2009 09:46AM
4336
March 28, 2009 04:04PM
4728
March 30, 2009 10:20AM
3785
March 30, 2009 01:10PM
3837
March 30, 2009 07:46PM
4011
March 31, 2009 07:57AM
5569
March 31, 2009 07:46PM
4135
April 01, 2009 02:47PM
Re: Character encodings issues with php, mysql, apache
3971
April 02, 2009 08:36PM
4151
April 06, 2009 12:04PM
8081
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.