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.

Options: ReplyQuote




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.