Web Wiz Forums - Case Sensitive and a Bug:

Print Page | Close Window

Case Sensitive and a Bug:

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=131
Printed Date: 29 March 2026 at 2:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Case Sensitive and a Bug:

Posted By: NewbieDude
Subject: Case Sensitive and a Bug:
Date Posted: 13 February 2003 at 10:48am

It appears that searches, passwords and user names are case sensitive on my setup. Is there a way to turn it off? I am using SQL 2000 as a backend.

Also when users register everything is cool and they get the confirmation page except if they filled out an e-mail address during registration - they get a page cannot be displayed. But it does still register them. Any ideas?

Thanks.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 13 February 2003 at 1:54pm

What version are you running.

And usernames and passwords are case sesitive.

The email error sounds like you have incorrectly setup email notification from the admin area, check with your host what they should be or just turn it off.

-------------
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: NewbieDude
Date Posted: 13 February 2003 at 3:01pm

Using 6.34

Is there a way to make it case insensitive? Example if I have a topic called TEST the only way to make the search find it is to search for TEST in caps. I notice on this forum it works either way.

The e-mail is setup is changed to CDONSYS. It works now. No error on user registration page when entering their e-mail address details. The e-mail notifications function properly. My bad.

Posted By: michael
Date Posted: 13 February 2003 at 3:27pm

In SQL Server you can select a 'sort order', while installing SQL Server. Sort order defines how the characters supported by the code page are compared and evaluated. The default sort order is 'case insensitive'. If you want SQL Server to perform case sensitive searches, you need to select binary sort order while installing SQL Server. In SQL 7 , sort order is defined at the server level, and cannot be manipulated at the database level. If you want to change the sort order of an existing instance, you must rebuild the master database using rebuildm utility. Not a pleasant thing to do. In SQL 2000 you can change that at the database level so no rebuild is necessary.

Posted By: NewbieDude
Date Posted: 13 February 2003 at 4:12pm

Ok thanks. It was set to binary on SQL 2000. I'll change the sort order on that database to default. Thanks again!