| 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