Each productfeed-standard specifies which type of input a field requires. This prevents wrong information to be added to the Daisycon feed system. In the following table you can find the SQL Data Types that the Daisycon feed system is using:
Legend
Type | Type description |
BOOLEAN | Only valid input: true, false of <empty> |
DATE | Date formatted as: YYYY-MM-DD |
DATETIME | Date formatted as: YYYY-MM-DD HH:MM:SS |
DECIMAL |
Numerical value with decimals seperated by a point, without other characters. |
INT |
Numerical value without other characters, "Unlimited" valued should be submitted as 99999 (5 times 9) |
LIST |
Textual value, one of the predefined options. |
TEXT | Textual value, all characters allowed, long text. |
TIME | Time formatted as: HH:MM:SS |
VARCHAR |
Textual value, all characters allowed, short text, a maximum of 255 bytes. |