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
10028
September 25, 2009 01:38PM
3491
September 26, 2009 05:48PM
3162
September 27, 2009 12:37PM
4329
September 27, 2009 05:44PM
3383
September 28, 2009 03:41PM
3592
September 28, 2009 03:49PM
Re: UTF8 Chinese String Comparison
3098
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.