Decimal delimiter option

If you create text-delimited or fixed-length format files, you can specify a period or a comma as a decimal separator. The period symbol is the default value. The comma separator is available for external tables and for the nzload command to help you to directly load data without extra preload conversion.

For the text-delimited format and for unloading data, this option is available only at the table level. For the fixed-length format, you can specify this option at the column level, making it possible to have a mix of comma and decimal separators.

The option is available for the following data types, for both text-delimited and fixed-length formats:
  • numeric
  • float
  • double
  • time
  • timetz
  • timestamp

Option usage for each data type is explained in the section that describes that data type.