Crawled Property Data Type is Always 'TEXT'

I've got several large Lob Systems mapped into the BDC, and have been using them and searching them successfully, until I realized a problem today, and I can't seem to find documentation about it.

I have fields in my entity of type DateTime, but when I go to create a managed property and map the crawled property from this field, the field is showing up as type 'Text', not 'DateTime'.

This keeps me from being able to search on the managed property as I would like, and also these crawled properties with incorrect data types don't appear to actually contain crawled data.

Is this a known issue? Is there some way around it?

[643 byte] By [KeirGordon] at [2008-2-25]
# 1

Keir,

Yes it is a known problem that the current BDC implementation has limited support for datatypes. It is expected that this will be improved in SP1 when that arrives.

Andrew

andrewwoodward at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...

SharePoint Products and Technologies

Site Classified