[sqlite] maybe bug in regexp and replace with newlines?

[Igor Tandetnik]

On 12/10/2015 9:01 AM, michael wrote:
> The statement:
> select distinct text from v_term_item where replace(lower(text),0x0A,'') 
> REGEXP('.*/some_text/.*');
> doesn't work like that:

Try x'0A' instead (that's a BLOB literal, and should be converted to a 
string). 0x0A is an integer, I suspect it gets converted to the string '10'
-- 
Igor Tandetnik