Re: Using a component in a filter query
sparrow wrote:Derek described everything.
It is advisable to simply replace the space character with an unused character. Then there will be no false positives.
Example:trim(ifnull(info1||'§','')||ifnull(info2||'§',''))
Hi all,
Any idea on how to translate this Sqlite version to MySQL? I get a ton of errors while trying to tweak it to fit MySQL and I am not far from the headache.
I got my answer, there is nothing to translate, one must enable the SQL_MODE "PIPES_AS_CONCAT" at the global parameter on the server.
SET GLOBAL sql_mode = (SELECT CONCAT(@@sql_mode,',PIPES_AS_CONCAT'));
I am wondering if it would be possible to push only a session sql_mode when the application connects to the server even after a timeout.