MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
Posted by: Rick James
Date: July 07, 2010 11:41PM

Override the collation for the '=':
SELECT HEX(CText), asciiValue, CText FROM `8888n8866` WHERE CText="รก" COLLATE utf8_bin

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
4815
stephen selvaraj
July 06, 2010 03:15AM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1891
Matthew Bagley
July 06, 2010 03:48AM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1870
stephen selvaraj
July 06, 2010 03:56AM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
2027
Matthew Bagley
July 06, 2010 04:48AM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1793
stephen selvaraj
July 06, 2010 07:31PM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1846
Rick James
July 06, 2010 10:28PM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1926
stephen selvaraj
July 07, 2010 08:18PM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1889
Rick James
July 07, 2010 11:41PM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1802
stephen selvaraj
July 08, 2010 01:43AM
Re: Dont know how to make SQL search for the column 'varchar' and collation 'utf8_unicode_ci'. Been spending more than a week. pls help
1883
Rick James
July 08, 2010 10:06AM


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.