| Author |
 Topic Search  Topic Options
|
patlis 
Newbie
Joined: 11 September 2007
Status: Offline
Points: 5
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Search engine problem
Posted: 11 September 2007 at 4:27pm |
Hi to all,
First of all i am sorry for my english, so
I have a forum with greek language, If i search a english word or a number, the search engine work good. If i try to search a greek word then the search engine they dont give results.
Can you help my?
Comments
EVERYTHIG else work good except searching
In MSSQL database i changed the text fields to nvarhar(max)
Thanks
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 4:29pm |
|
Sounds like you need to change the page encoding that the browser is working in.
If you are using 9.04 or above, edit the includes/setup_options_inc.asp file and set the correct page encoding for both web pages and RSS Feeds.
|
|
|
|
patlis
Newbie
Joined: 11 September 2007
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 4:33pm |
Thaks for your quick answer!
I allready set the encoding to utf-8
my page is http://www.gardensandplants.com/forum_gr
Edited by patlis - 11 September 2007 at 4:36pm
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 4:37pm |
|
Yes but you have also siad that you have set CODEPAGE="65001" which is different to utf-8
So the front end is working in one encoding, while behind the scene the server is using a different encoding.
This can lead to issues as both will store and use non-English characters in different ways, thus coursing issues with things like searching.
You have also changed data types to nvarchar, again this alters the way text is stored.
It seems that you have modified a number of areas, which in turn prevents searching from working.
Edited by -boRg- - 11 September 2007 at 4:39pm
|
|
|
|
patlis
Newbie
Joined: 11 September 2007
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 4:49pm |
Thanks again,
Sorry but i can't anderstand you.
what must to do?
I tryied to remove the first line ...CODEPAGE="65001" but nuthing
Do you have an idea?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 5:02pm |
|
The data will already be stored in the wrong format.
You need to put the forum back to how it was with correct database datatypes, correct encoding etc. then when you post new posts they will be searchable.
|
|
|
|
patlis
Newbie
Joined: 11 September 2007
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 September 2007 at 5:04pm |
|
Thanks!
|
|
patlis
Newbie
Joined: 11 September 2007
Status: Offline
Points: 5
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 September 2007 at 11:30am |
Finally it was very easy to solve the problem.
In search_process.asp I add an "N" after "LIKE" and before "'%"
Now it shows " LIKE N'%" and before was " LIKE '%"
Best regards
|
|
