Non-printable characters in SQL

Posted in 1999

Ian Bishrey — Fri, 26 Feb 1999 08:58:43 -0000 — source: Informix-list mailing list archive (1991-1998)

Hi, Does anyone know of a way to insert non-printable characters in an INSERT command VALUES section for string literals? PostgreSQL uses "\\xHH" to allow arbitary hex characters within a string (e.g. 'Single quote is \\x27 carriage return is \\x0D') but I don't think this is a standard. Any ideas? TIA Ian