Importing spaces
511980Aug 10 2006 — edited Aug 10 2006Hello
I am trying to import a csv file which contains two columns, the first is the unique identifier, the second contains the data required to be viewed by an end user. This data contains a lot of white spaces, which I want to keep and import. Is there a way of doing this, as whenever I have tried to import this data, the import process seems to trim all the multiple spaces to 1. I have tried changing the table field type to both varchar2 and clob and neither make a difference. Any ideas?
Cheers Ian