Inserting Values as Quoted Strings

In the default locale, if you are inserting a value that is a quoted string, you must adhere to the following restrictions:

Enclose CHAR, VARCHAR, NCHAR, NVARCHAR, DATE, DATETIME, INTERVAL, and (for Dynamic Server) LVARCHAR values in quotation marks.
Specify DATE values in the mm/dd/yyyy format (or in the format that the DBDATE or GL_DATE environment variable specifies, if set).
In Extended Parallel Server, you cannot insert strings longer than 256 bytes.
In Dynamic Server, you cannot insert strings longer than 32 kilobytes.
Numbers with decimal values must include a decimal separator. Comma ( , ) is not valid as a decimal separator in the default locale.
MONEY values cannot include a dollar sign ( $ ) or commas.
You can enter NULL in a column only if it accepts null values.

For a discussion of the DELIMIDENT environment variable, see the IBM Informix Guide to SQL: Reference.

For a discussion of the GLS aspects of quoted strings, see the IBM Informix GLS User's Guide.