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

[michael]

>/> 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

thanks but sadly it also doesn't work