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.
Subject
Views
Written By
Posted
10366
September 25, 2009 01:38PM
3592
September 26, 2009 05:48PM
3252
September 27, 2009 12:37PM
4463
September 27, 2009 05:44PM
3500
September 28, 2009 03:41PM
3727
September 28, 2009 03:49PM
Re: UTF8 Chinese String Comparison
3225
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.