Search in Hebrew returns 0 results


https://forum.kartris.com/Topic3135.aspx
Print Topic | Close Window

By bpaluch - Tue 10 Jun 2014
Hi, I have some product names in Hebrew, and the search doesn't pick them up. I see the search passes as a GET request, and the HEBREW shows correctly in my URL, but is that picked up correctly by the page?

Will the page work if I change to a POST? Anyone have experience with the search and non-alpha characters?
By bpaluch - Wed 11 Jun 2014
Hebrew search works fine in the backed...(I knew I had tested this previously!), but not in the front end. I noticed a difference...backend does encode and front end doesn't...so I added a javascript urlencode function, and now the front end search passes the EXaCT SAME encoded value to the search as the backend sends to the backend search.

But still, front-end search only shows English results, and no Hebrew results...what now?
By Paul - Thu 12 Jun 2014
I've emailed you regarding this, but just wanted to update the forum on this.

I think the issue isn't to do with the passing of querystrings, but is an issue with the spKartrisDB_Search sproc (and the FTS one, if you're running that). Internally this does a fair amount of string processing. In many places, this appears to convert text into varchar type (rather than nvarchar); also, places updating fields with string values are in many cases not prefixed with 'N' which is required for unicode values.

I've updated these sprocs within the setup .sql files, and the most recent update .sql file, which should fix this. I've found things seem to work ok in Hebrew, but still have some issues in Chinese because there are no spaces between characters.

A good workaround I've found for that is to add the individual words, separated with spaces, into the keywords SEO field (which is also searched by the main search, so can be used to put misspellings or alternative words for things too for western languages).