Re: UTF8 Chinese String Comparison
Posted by: Rick James
Date: September 28, 2009 11:41PM

There must be a way. It may involve creating another column and using select/insert/update to copy the values from one column to another. Possibly a cast would be needed. Possibly the extra column would be a BLOB (or VARBINARY) and it would take two copies. Also there is ALTER TABLE ... CONVERT TO CHARACTER SET ... Sorry, I don't have the energy to figure it out. Glad you got your data fixed.

Options: ReplyQuote


Subject
Views
Written By
Posted
9854
September 25, 2009 01:38PM
3424
September 26, 2009 05:48PM
3118
September 27, 2009 12:37PM
4280
September 27, 2009 05:44PM
3313
September 28, 2009 03:41PM
3537
September 28, 2009 03:49PM
Re: UTF8 Chinese String Comparison
3042
September 28, 2009 11:41PM


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.