Print Page | Close Window

Search engine problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24386
Printed Date: 06 April 2026 at 5:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Search engine problem
Posted By: patlis
Subject: Search engine problem
Date 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
I add to all pages the < mailto:%@LANGUAGE=VBSCRIPT - %@LANGUAGE="VBSCRIPT " CODEPAGE="65001"%>
EVERYTHIG else work good except searching
In MSSQL database i changed the text fields to nvarhar(max)
Thanks



Replies:
Posted By: WebWiz-Bruce
Date 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.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: patlis
Date 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


Posted By: WebWiz-Bruce
Date 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.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: patlis
Date 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?


Posted By: WebWiz-Bruce
Date 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.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: patlis
Date Posted: 11 September 2007 at 5:04pm
Thanks!


Posted By: patlis
Date 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
 



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net