In Hyperstage, when you export CHAR(n) data type values to a text file, the extra spaces are trimmed from the export.

The Hyperstage and MySQL Loaders support escape character definition and usage.

Hyperstage recognizes the following representations of NULL values when loading data from a text file:

NULL, \N, <field delimiter><field delimiter>

However, Hyperstage only exports NULL values in the following representation:

<field delimiter><field delimiter>

Other DBMS systems may have different representations of the NULL value. For example, MySQL only recognizes the representation \N for a NULL value. This can create issues if you export data from Hyperstage and import the data into MySQL. Since MySQL will only look for \N and will not recognize the Hyperstage representation of the NULL value, MySQL will change the NULL value into the default values in numeric and string columns.