Re: accessing informix via ODBC...

Informix space pads char columns and varchar columns to full length for type CHAR and FIXCHAR host variable types. The ESQL host variable types VARCHAR and STRING strip trailing spaces from CHAR columns and any trailing spaces in a VARCHAR that were not inserted specifically. The equivalent ODBC type is probably SQL_VARCHAR. Art S. Kagel Rob Stevens wrote: > > hi > > I'm currently accessing an informix db (informix se v.7.23) from vb via ODBC > (Informix client sdk (odbc driver ver 3.31)) and I'm getting data back > fine...except that all the text fields are being shown space-padded (the > actual data isn't space-padded)! even if I link to the db using Access the > fields are coming back to me space-padded, so I think the problem may be > some setting that I'm missing from the ODBC setup. > > the client PC is Windows2000 and the server is a SCO box btw. > > TIA > Rob > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----