Hello Gentlemen,
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ÃÂ ÃÂ ÃÂ ÃÂ
Murali
redÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
WhiteÃÂ ÃÂ ÃÂ ÃÂ
Yellow
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.
ÃÂ
__bk82007400270056005600e60002000200020002000200
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: