Subject | Stop IB_Import stripping whitespace ? |
---|---|
Author | sam.howley |
Post date | 2009-08-09T16:17:48Z |
Hi,
I'm using IB_Import to get a CSV into a Firebird table.
I am finding values that have trailing spaces appear in the database
without the trailing spaces.
Mudgee , 1234
Sydney, 232
will appear in the database as
'Mudgee', 1234
'Sydney', 232
The trailing space has been removed from 'Mudgee'.
Is there a way to retain whitespace ?
Cheers
I'm using IB_Import to get a CSV into a Firebird table.
I am finding values that have trailing spaces appear in the database
without the trailing spaces.
Mudgee , 1234
Sydney, 232
will appear in the database as
'Mudgee', 1234
'Sydney', 232
The trailing space has been removed from 'Mudgee'.
Is there a way to retain whitespace ?
Cheers