I have a varbinary field id like to do a case-insensitive search on.
I know that the way varbinary fields work prohibits you from doing something like so:
WHERE LOWER(page_title) = LOWER("Gasket")
So is there a way to do this? I imagine I could temporarily cast the field as a varchar or something. But I'm not sure.
You can use the CONVERT()
function:
SELECT * FROM mytable WHERE CONVERT(page_title USING latin1) = 'gasket';
See also Case Sensitivity in String Searches
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With