Norwegian characters problem with eZ Standard Search

Thursday 16 September 2010 5:13:24 am

Hi guys (and girls)

I am having some problems with the search. The problem is I wan`t to search after a object called "La deg inspirere". I know its in Exponential. But it will not show. After debugging I found the reason. The search for phrase is splitted up to find the words in a order. And this causes some problems. Because in the sql-tables there is a word "La" but also a word "Lå". This results in that the string match must be "La Lå deg inspirere".

Anyone had the same problem, and could provide me with a solution?

I have tried to truncate the ezsearch_object_word_link table and run the bin/php/updatesearchindex.php --clean -s nor but that gave me no luck.

Looking forward to get some replies from you hard core Exponential people :-)

Sincerely,

Anders Sandvik Berre
http://www.netmaking.no/

Thursday 16 September 2010 11:56:02 pm

Hi Gaetano,

And thanks for your reply. Yes It will in this case be overkill. So I need to find an soloution that will work on standard search.

Sincerely,

Anders Sandvik Berre
http://www.netmaking.no/

Friday 17 September 2010 3:46:44 am

Ah, at last. The forum told me to login, but I was logged in. But every time I loaded this page the page thought I was not logged in...

Anyway. The problem is isolated to the sql-queries. So if its Exponential that fails or its the sql-database, I really don`t know. But I guess its the database. I tried to run SELECT * FROM .. where I putted the word='La'. This result in two rows. In with La and one with Lå.

Sincerely,

Anders Sandvik Berre
http://www.netmaking.no/

Monday 20 September 2010 12:12:37 am

Hi André,

Thanks for your reply. Collation is set to utf8_general_ci.

What do you mean by (& connection)?

Sincerely,

Anders Sandvik Berre
http://www.netmaking.no/