How to Searching a unicode data if we have Image Data Type within our SQL Server 2000.
Hi, I have the problem with to finding a data from Image Data type using Full Text Catalog if i have some unicode data to find.
so tell me solution to applying a Full Text Catalog to Image Data type which contains some Unicode value.
waiting for your response soon.
i have to find some "Hindi Text" which stored in Image data type and have to find using SQL full text catalog.
Please help me in this manner.....
Is there any budy to help in this aspect I need urgent Help. Please. Solution Please....
Hi RML_NLD,
Thing is like I have an application which has an editor just like this editor. so whatever contents we have written on editor, it saved in Image DataType. I may have some hindi text as well. suppose i want to find some hindi text within our column, i need to have full-text catalog. so here my Question is: i have an Image Data Type with Column name 'ResourceText' which is contains also some unicode data as well. now i want to find some unicode data from that particular Column, how do i that
If i have only English character on editor & stored in Image data type column, i am able to find it with the help of Full-Text Catalog, but now suppose i have some characters rather than English one, suppose consider an "Hindi Character" , & storing a all contents in that particular column, i m unable to find a that character using Full-Text Catalog. so i need a solution that how do i find some unicode data from Image Data Type using Full-Text Catalog.
e.g.
select * from tblResources where FreeText (ResourceText,' ')
I am unable to find this '' " text from ResourceText which is Image Data Type in SQL Server 2000, but if i try to search something like:
select * from tblResources where FreeText (ResourceText,'English word'),
then it shows me desired result. so my Full Text catalog is not supported for that as i guess to find some some text rather than English characters.
i don't want to take ntext because Editor may contains so many things like Images and Everything like that. So how to do with Image Data type to find some characters rather then English one.
I hope you understand my problem & will help for the same. waiting for your response soon.
Dear, Thanks in Advance for helping me in this manner
I am using SQL Server 2000.
Thanking You,
Harshal Choksi
For the process of indexing Full Text, the proper word-breaker must be used. You can pick a language of your choice from the dropdown in the window where you configure a FTC. The choices depend on the installed languages on you OS. If you want to add more, see BOL for that.
You might want to consider changing the collation, since SQL-server uses that for indexing and searching in text. I'm not sure if there is a collation type for Hindi. And I'm not sure what happens if you combine Hindi and other languages.
Hi, RML_NLD
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.
Is there a possiblity that 2 languages are in 1 database-field (1 record) If not, you might want to create a column for each language for the text. You need your SiteID to determine what field to use. I know you can configure a collation for every field in SQL2005, for SQL2000 I'm not sure. If you cannot create a different collation for the different language columns, you have to split the texts into different tables.
Maybe using a query like '... where FreeText(ResourceText, '" " or "infromation"')' might help
About the conversion of image-data: you cannot do that via TSQL. I hope you know your way in programming, because that would make it easier for you. Based on ADO.NET (for example), you can loop through the table, read the image-field, convert it to text and write it to an other field. Remember that you can store a certain amount of characters varying on the data-type (nvarchar max 4000, varchar max 8000).
I hope it helps you a little further.
Hi RML_NLD,
I thing this is quite conusing for me to create to two column to save the contents in diffrent diffrent language. because a problem is how do i differ those text, it could be any of our language.& we are saving whole contents of Editor into one column, in this case, we have Image Data type so we are storing whole the content into Image Data type.means whatever contents we might have,it could be hindi or English,(unicode data or not unicode data), now i want to find some particular keywords within that, again it could be "hindi" or "English",i want something like using Full Text catalog we can read that particular column which is Image Data type & finds that word what user want to search & if it is there ,then it has to show else not.
I hope you understood this concept, & one more thing i need to ask can we have some another data type rather than Image Data type & also which supports us Full Text catalog & also have a big size, i thing ntext is best option but here we can not do such kind of thing because we may have image as well on Editor & may be possible that we may have Long content as well.may be exceed than 8000 characters.so tell me how to do that i have been trying to solve this problem since last week,but yet not find any solution for that. here i m talking about Hindi language only,but the same problem i m getting on German language as well.
Thanks your lot co-operation in this matter but i am really worried about this problem,how to solve that it makes me completely not making any sense to solve it,so help as much as you can. 
Hi RML_NLD,
Could you find any solution for this Please help me out in this aspect. i will greatfult to you
Thanks in Advace,
Hi RML_NLD,
I am still waiting for your response. Please help me as soon as possible. how to search a "Hindi" or any characters written in any langauge rather than just being of English charcters using Full Text Catalog in SQL server 2000
please please if you have any solution,please let me know as i have some emergency task
Hi All,
Could any one of you tell me how to find a unicode data within a Image data type using with Full Text Catalog
i can't take ntext for that because i may have images + some text (unicode + non unicode data) as well. so in my application i have editor in which i amy have Images and some text(unicode + non unicode data) as well.so i want to find text within a Image Data Type using Full Text Catalog how I am unable to get result using Full Text Catalog.... i able to find only text with "English" keyword but not able to get any other character rather than "English" characters.
so i have problem with to finding a unicode data (which is not "English" text)
so please help me any one of you.......
i will be waiting for your response soon..... i will be greatful to you if you do so.
Thanking You,
Harshal Choksi