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.