Field data difference between TQuery and TUniQuery

[bgacorrie]

Using the same sql command in both attached to an MSSQl server database.
I am seeing training spaces on some data in specific fields but not in others with TUniQuery or TUniTable. TQuery displays it fine.

There is no training spaces in the data.

Fields are varchars and it is not all of the fields just some. Looks to be 6 characters no mater the length of the data.

Very strange

I must be missing something

[bgacorrie]

More info on this.

Tried this with Oracle and it works fine. Must be the SQLProvider.
I am connecting to MSSQL 2005

[bgacorrie]

I found the cause it was in a script that loaded the data it was loaded as a char type instead of a varchar. not sure why tuniquery and tunitable cared while tquery and ttable didn't but at least I know know.

[azyk]

Please try to compose a small sample reproducing the issue and send it to andreyz*devart*com. Include the scripts for creating the table-source and table-recipient.