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
9876
September 25, 2009 01:38PM
3441
September 26, 2009 05:48PM
3121
September 27, 2009 12:37PM
4286
September 27, 2009 05:44PM
3320
September 28, 2009 03:41PM
3542
September 28, 2009 03:49PM
Re: UTF8 Chinese String Comparison
3045
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.