Search code examples
mysqlsqlheidisql

\n in INSTR SQL

When I make a 

(select instr(hist.texte, '\n'))

I find 0 while there is \n in my text.

I don't have this error with another character chain.

Is it the "\" which could be a problem?

Thanks in advance,

Solution

  • If you're speaking about text, literally typed in your string, then you should escape \n since DBMS will treat \ as escape-sequence symbol. So following will work:

    SELECT INSTR(hist.texte, '\\n')