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 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).
• 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.