yeah you are right, but thing is like we are making an application,by using we are producing(delivering,making) site like English,German and Hindi etc. etc. so suppose we have site English, and anybudy will write any keyword to search, if it is English Site,so related that document will be displayed. & if we have an hindi site,so it has to find within that column,so if it is Hindi site, then whatever contains you search for like " ",it has to find within that Image data type.so we will have only one database & all the site must be running from that database only.so i do such kind of things on based on siteId, so if anybudy open a related site suppose English then, whatever siteID we get,used to display a data accordingly. & same for hindi as well
so just like some condition such as
select * from tblResources where FreeText (ResourceText,' information') And siteId = 1
Note: here ResourceText is Image Data type:
where siteId = 1 is defined for English and so we are passing a dynamically SiteId as par Url hit.So thing is like i can't say that one collation we may have to work for.
now problem here we have, we saved all contents in one column which has a Image data type,so may be possible we may have both the contents English as well as Hindi.so any user finds search with hindi keyword for one site,so accordingly data has to displayed.like " information",if user try to find a word " " then whole data must be displayed & also possible that user may write "Information" keyword as well.so same thing has to display. this is what i am talking about one site only,
I hope you understand my scenario. & help me in this problem. here we are using SQL Server 2000, not advanced version like 2005
is it possible to convert this Image Data type into some another data type where we can apply indexing Catalog, i thing indexing service won't be support to image data type if we have any unicode character which we need to find with the help of Indexing service.
Thanks again for your help me & try hard for me to rectify this problem. waiting for your response soon.