Re: Trailing spaces in char fields with ADO.Net and OleDB
This is a discussion on Re: Trailing spaces in char fields with ADO.Net and OleDB within the Informix forums, part of the Database Server Software category; --> There is no attribute called "trim char=true" in connection string for Infomrix .NET Provider. However you should be able ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:33 PM
| ||||
| ||||
 Re: Trailing spaces in char fields with ADO.Net and OleDB There is no attribute called "trim char=true" in connection string for Infomrix .NET Provider. However you should be able to do string.Trim() and/or you might think of using VARCHAR instead of CHAR column. -Shesh "Philippe Requilé" <Philippe.Requile@falcon.be.nospamplease> Sent by: informix-list-bounces@iiug.org 14/02/2008 12:44 To informix-list@iiug.org cc Subject Trailing spaces in char fields with ADO.Net and OleDB I use the ado.net IdxConnection to connect to an informix database. Unfortunately every field of type char in the dataset has trailing blanks. How can I get rid of them? (In DbExpress I could put "trim char=true" in the connectionstring.) _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list      |
Linear Mode
