FiveTech Software tech support forums

Code: Select all  Expand view

SELECT * from vll_term WHERE WORT LIKE '%' + UNHEX('C39F') + '%'

Code: Select all  Expand view

SELECT * FROM vll_term WHERE WORT LIKE CONCAT('%', UNHEX('C39F'), '%');

Code: Select all  Expand view

SELECT * FROM vll_term WHERE WORT LIKE '%ß%');
 

frose wrote:

Code: Select all  Expand view

SELECT * FROM vll_term WHERE WORT LIKE '%ß%'); 

Code: Select all  Expand view

SELECT * FROM vll_term WHERE WORT LIKE CONCAT('%', _utf8'\u00DF', '%');

Certainly, if you're constrained to plain SQL without access to specific MariaDB functions like HEX() and UNHEX(), performing character matching using UTF-8 hexadecimal representations directly within a LIKE statement becomes challenging...

... Unfortunately, in plain SQL without access to database-specific functions, performing character matching using UTF-8 hexadecimal representations directly within LIKE might not be feasible.

frose wrote:But when I want to use hex codes for the search string, MariaDB has HEX() and UNHEX().
What is the equivalent in plain SQL?