Web Wiz Forums - Search engine problem

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