| Subject | External files and nulls |
|---|---|
| Author | chris.bland@blueyonder.co.uk |
| Post date | 2003-04-14T16:44:50Z |
Hi there,
We are using external files. We have varchar data with nulls in FB. When exporting this data to an external file, upon hex examination, a null value appears to be a series of NUL characters. When this is reimported, or selected, FB seems to interpret these as empty strings. The "null" has disappeared, and we now have empty strings. Is this correct behaviour, or are we doing something wrong? Is there a way to encode nulls?
It is FB1.0 running on Win2k.
Regards
Chris
We are using external files. We have varchar data with nulls in FB. When exporting this data to an external file, upon hex examination, a null value appears to be a series of NUL characters. When this is reimported, or selected, FB seems to interpret these as empty strings. The "null" has disappeared, and we now have empty strings. Is this correct behaviour, or are we doing something wrong? Is there a way to encode nulls?
It is FB1.0 running on Win2k.
Regards
Chris