Case Sensitive and a Bug:

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
NewbieDude Members Profile Find Members Posts Newbie Joined: 13 February 2003 Status: Offline Points: 4	Post Options Post Reply Quote NewbieDude Report Post Thanks(0) Quote Reply Topic: Case Sensitive and a Bug: 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

NewbieDude Members Profile Find Members Posts Newbie Joined: 13 February 2003 Status: Offline Points: 4	Post Options Post Reply Quote NewbieDude Report Post Thanks(0) Quote Reply 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.

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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. Edited by michael

NewbieDude Members Profile Find Members Posts Newbie Joined: 13 February 2003 Status: Offline Points: 4	Post Options Post Reply Quote NewbieDude Report Post Thanks(0) Quote Reply 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!

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum