Here I am experimenting the BDC with a simple example of pulling distinct data from a sql server 2005 to a sharepoint list column "SELECT distinct Color FROM Product" .
BlueÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
GreenÃÂ ÃÂ ÃÂ ÃÂ
redÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
WhiteÃÂ ÃÂ ÃÂ ÃÂ
when i configured the bdc using Business Data List the data showing correct. But when I use this it in a list column with bdc data type itsÃÂ returnig me the binary type of data.
No exact match was found.
However in the bdc picker the data is displaying properly. The data type in sql is nvarchar. I tried changing different data types but its showing the same kind of it.
Here is the BDC: