losing blank space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm filling a DataTable with data from a Sybase database table via ODBC provider. I have a varchar(10) column in the database table that stores " " (one blank character) as valid data for special cases. Once I fill my DataTable, the data rows contain empty string for this column "" instead of " " (one blank character) for these cases. I've verified the blanks actually exist in the database. Has anyone ran into this before?

I could perform workarounds, but I'd really appreciate any insight to what is happening.

Thanks,
Jake
 
Hi,

I think it is a provider's issue. Did you try to use ASE OLEDB for Sybase
provider to see if it works or not?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataTable ColumnChanging event nit firing on adaptor.Fill() 1
Second fill in Ado.recordset does not fill table 4
dataset WriteXML question 1
Excel and OleDbDataAdapter. How can i ignore blank columns 2
How to fill a datatable with data from another datatable 2
.Net 2.0 Autogenerate update command parameters from a disconnected datatable 3
DataBind() Causes Connection Pool to overflow? 1
Insert into Table from Manually Built DataTable 3

Back
Top