Outlook 2010 How to retrieve user defined fields values to bcm form.

nisha

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
Currently I am saving user defined fields to sql server 2008 as varbinary(512). but when I retrieving those values
to BCM form it is displaying as not correct format.
Which format we need to save user defined fields to BCM database?
 

nisha

Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
I need to save varchar(max) sql datatype data to BCM userfields column.I tried to convert varchar data to varbinary(512) following way
DECLARE @var varchar(200)
CAST(@var As varbinary(512))

I convert varchar value to varbinary and save to BCM database.But When I view this record in outlook screen,That record is not displaying correctly.Please let me know how to convert varchar value to varbinary and view correct value in outlook screen
 
Top