Import from Oracle nulls issue

[trevc]

Am importing from an Oracle table where a Date column is null. Instead of placing "" or null into the FileMaker Field, it appears to put in some sort of time stamp i.e. 10:15:39.

I've tried different FileMaker field types thinking this may be the issue (Date, timestamp, text) and still the same issue.

Using RapidSQL to view the data in the table confirms that the data is 'null'.

[Squeaky Data]

Any chance that the FileMaker field you are using has an auto entered time stamp?

[trevc]

Worth checking ... no. At least I have a workaround as it's consistent so I can find/replace on the import script.