Web Wiz Forums - Search words with accents

Print Page | Close Window

Search words with accents

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=26804
Printed Date: 03 April 2026 at 12:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Search words with accents

Posted By: perlmonge
Subject: Search words with accents
Date Posted: 09 January 2009 at 12:21am

Hello,

We have experiencied a little issue with accents when you perform a search for a word with accents.

For example: Atenção and Atencao are considered different words, but in may forums apps, accents are not considered in searches

Any solution for this thing?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 09 January 2009 at 8:55am

This is controlled by your database engine. Accented and non-accented searches depend on what database you are using and how you have setup the database. What character set you use for your forum and which collation you use for your database tables.

For example if your database is SQL Server and you use the collation SQL_Latin1_General_CP1_CI_AS - the "AS" at the end means "accent sensitive".

-------------
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