Re: chinese full-text search
From: Prudhvi Raju (PrudhviRaju_at_discussions.microsoft.com)
Date: 11/22/04
- Next message: RGM: "Determine words found??"
- Previous message: David Gugick: "Re: Run Multiple Stored Procedures in order with a script??"
- In reply to: Hilary Cotter: "Re: chinese full-text search"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 01:09:06 -0800
Thanks Hilary for the advice.
I've included BIG5 codepage and also changed the meta tag to
<META http-equiv=Content-Type content="text/html; charset=big5">
and am now able to get the result set for chinese search.
Thank You.
Regards,
Prudhvi
"Hilary Cotter" wrote:
> You need to set the code page in your asp page.
>
> Run profiler to see the command that hits SQL Server. I think what is
> happening is that the chinese characters being entered on your web server
> are not making to SQL Server as Chinese characters, rather their character
> representations in the 1252 code page. Hence no hits:)
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
>
> "Prudhvi Raju" <Prudhvi Raju@discussions.microsoft.com> wrote in message
> news:8B136C72-FD83-4BF8-8A59-C5B263294E46@microsoft.com...
> > I've haven't set the session code page but included the meta tag
> >
> > <META http-equiv=Content-Type content="text/html; charset=windows-1252">
> >
> > "Hilary Cotter" wrote:
> >
> >> Did you set your session code page for Chinese simplified or Traditional?
> >>
> >> --
> >> Hilary Cotter
> >> Looking for a SQL Server replication book?
> >> Now available for purchase at:
> >> http://www.nwsu.com/0974973602.html
> >>
> >> "Prudhvi" <Prudhvi@discussions.microsoft.com> wrote in message
> >> news:0A2D4FD7-8E9F-4C6C-BC5E-D0CA84B6E284@microsoft.com...
> >> > Hello,
> >> >
> >> > Request your help on querying a Fulltext indexed table with Chinese
> >> > Text.
> >> >
> >> > I have sql server 2000, and a database with Chinese collation, a table
> >> > is
> >> > full text indexed with Chinese(RPC) word breakers.
> >> >
> >> > I am able to retrieve the Chinese text from the table and successfully
> >> > display the same on the browser but am not able to search.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > What is happening is when I run the below query in query analyzer, it
> >> > is
> >> > returning me a result set
> >> >
> >> >
> >> >
> >> > SELECT * from DCNews_Live where contains (*,' "chinese text" ')
> >> >
> >> >
> >> >
> >> > Where as when I run the same query from ASP (Active Server Pages) it is
> >> > not
> >> > returning any values.
> >> >
> >> >
> >> >
> >> > Can u explain where I am going wrong?
> >> >
> >> >
> >> >
> >> > The ASP code that I use is
> >> >
> >> >
> >> >
> >> > strSearch = trim(request.Form("txtSearch"))
> >> >
> >> >
> >> >
> >> > strSql = "SELECT * from Table where contains(*,' """ &
> >> > strSearch
> >> > & """ ')"
> >> >
> >> >
> >> >
> >> > objRs.Open strSql,objCon
> >> >
> >> >
> >> >
> >> > The Recordset is empty.
> >> >
> >> >
> >> >
> >> > Can u please help out of this
> >> >
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Prudhvi Raju M
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>
- Next message: RGM: "Determine words found??"
- Previous message: David Gugick: "Re: Run Multiple Stored Procedures in order with a script??"
- In reply to: Hilary Cotter: "Re: chinese full-text search"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
