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: Matthew Bagley
Date: July 06, 2010 03:48AM

I think the best way to do this would be to add another column to your table and have the value as A, this way you just query the table SELECT * FROM tablename WHERE column = 'A' instead of a complex query that you don't really need in my opinion.

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
1890
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
2023
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.