> 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.

This likely has to do with the FieldsTrimming property.

> 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 ?

Yes. Use the FiledsTrimming property. It also affects input parameters.

You may even be able to flip the global switch on the database to turn all
trimming off.

Jason LeRoy Wharton