Extracting a full table from SQL server

I have an issue if I extract a full table from SQL server it shows several columns as blank even through they have data... If I extract just those columns the data shows up correctly.

Any help around this would be great, I am now running version 5.6.1.3

Derec

What are the field types?

Mike

Hi Mike,

I have resolved the issue it was to do with text types and varchar types.

Thanks,
Derec

I see...

It is a feature of SQL server ODBC driver
Basically if you have blob fields eg ntext,text etc
You should put them last in the sql, otherwise it will not work.

eg

select integer_field, varchar_field, text_field from table

Mike