El Jueves, 14 de Enero de 2010, Jeremy Evans escribió:
> while PostgreSQL and MySQL are case sensitive for like and case insensitive
> for ilike.
This is not what happens in my system:
MySQL 5.1.30 (Ubuntu) behaves case insensitive for "LIKE" and "=" operators
when using them in a type "char" field.
I need "=" to be case sensitive but I use prepared statements:
DB[table]. \
filter(:user => :$n1, :doc_uri => :$n2). \
select(:id, :etag). \
prepare(:first, :ps01)
I suspect I must configure my MySQL server to behave as case insensitive,
right?
--
Iñaki Baz Castillo <[email protected]>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
