Group: Forum Members
Last Active: Thu 23 Jul 2020
Posts: 70,
Visits: 175
|
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?
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
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).
-- If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|