[dev.icinga.com #234] change string escaping in idoutils

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/234

Created by mfriedrich on 2009-12-17 16:35:09 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2010-01-08 15:20:01 +00:00)
Target Version: 1.0.1
Last Update: 2010-01-08 15:20:01 +00:00 (in Redmine)

---

the string escaping for special characters is kind of fucked (mysql)

so it would be nice to only escape those characters which may be wrong interpeted by the rdbm.

mysql:
http://dev.mysql.com/doc/refman/5.1/en/string-syntax.html

\0 An ASCII NUL (0x00) character.
\' A single quote (“'”) character.
\" A double quote (“"”) character.
\b A backspace character.
\n A newline (linefeed) character.
\r A carriage return character.
\t A tab character.
\Z ASCII 26 (Control-Z). See note following the table.
\\ A backslash (“\”) character.
\% A “%” character. See note following the table.
\_ A “_” character. See note following the table.

' might be escaped using '' instead, the rest is already sent over the socket.
so it might be useful to change that for mysql like oracle has it.

[icinga-migration]

Updated by mfriedrich on 2010-01-08 15:20:01 +00:00

• Status changed from New to Resolved
• Done % changed from 0 to 100

changed and tested in git master.