| Searching in Hebrew [message #35801] |
Fri, 09 February 2007 22:50  |
syslin
Messages: 14
Registered: February 2007
Karma: 0
|
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 |
|
|
|
|
|
|
|
| Re: Searching in Hebrew [message #35826 is a reply to message #35801] |
Wed, 14 February 2007 23:14  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The search system is implemented by breaking text into words and creating a word index based on those words. I am guessing utf-8 representation of hebrew breaks on this. One we have an official Hebrew support we'll look into making the search work
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]