FUDforum: How To » Searching in Hebrew

Home » FUDforum » How To » Searching in Hebrew

Show: Today's Messages :: Polls :: Message Navigator

Searching in Hebrew [message #35801]

Fri, 09 February 2007 22:50

syslin

Messages: 14
Registered: February 2007

Karma:

Junior Member

Hi friends,
So I translate (and now I have to check) the FUDforum to support Hebrew too, and all look good but the search does not working when I want to search for Hebrew string.

I change the Locate to he_IL.utf8 and then I added a new topic. the Subject is in Hebrew and the body text is mixed Hebrew & English.

When I tried to search, I entered the subject text in Hebrew and the search engine return no results. Then I tried to search in hebrew for some text in Hebrew that exist in the body on the message in the same - no results. When I did a search in English on the text intoo the body of the message and I GOT a results.

So... I wrote a simple PHP file that connect to the mySQL database server and use a select query on the fud26_msg tables and print the subject in the browser - it woek fine I saw the hebrew. Then I add to the SELECT query a WHERE subject LIKE '%(Hebrew Text)%' and it works great.

I tried to use "SET NAMES UTF8" before entering data and before query data but it didn't solve my issue.

Any Idea?

Thanks
Miki

[Updated on: Fri, 09 February 2007 22:50]

Report message to a moderator

[Message index]

		Searching in Hebrew By: syslin on Fri, 09 February 2007 22:50
		Re: Searching in Hebrew By: syslin on Mon, 12 February 2007 20:43
		Re: Searching in Hebrew עברית By: syslin on Wed, 14 February 2007 12:31
		Re: Searching in Hebrew By: Ilia on Wed, 14 February 2007 23:14

Previous Topic:	just a question
Next Topic:	Change the date format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:55:03 GMT 2024

Total time taken to generate the page: 0.04663 seconds