Case sensetivity and SELECT problem

[saidbakr]

I have a created a table in a database. In one of its column, I have to insert some data in Arabic, where its alphabatics are symbolzed in ASCI greater than 127, however, to keep Arabic data to be displayed in correct alphabatical order, I must set this field as Binary.
Ok.
However, this leads to Case sensetivity problem when I try to select a record in any latin alphabaics, like English, from this table.
To clearfy that situation, look at the following Example:
Suppose;

SELECT * FROM mytablename WHERE myfield = 'boolmx'

Ok, In myfield already I have data = BoolMX.
So, due to case sensetivity, the query does not find any thing.

Now, I need case senstivity to be neglected and at the same time I want to keep this field to be Binary.
Is this Possible? and How?
🙁

[ahundiak]

You can use the BINARY keyword right in your select statement.
SELECT BINARY "a" = "A";
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html

Or keep the field as binary and use the sql UPPER() function.

[Sxooter]

What database are you using? Case folding tends to be database engine specific.

[hi-liter]

would it be possible to do something like?

SELECT * FROM mytablename WHERE myfield REGEXP 'boolmx'

manual states:

To find names containing a lowercase or uppercase `w', use this query:

mysql> SELECT * FROM pet WHERE name REGEXP "w";

just a thought that maybe it'd work??

this assumes MySQL...

[Sxooter]

If you're using Postgresql you can either use ILIKE

select * from table where field ilike 'bubba';

OR you can use regex:

select from table where field ~ 'thomas';

[saidbakr]

I use MySQL 4
I will try your valuable advices soon:p