Hello.am using
sqlserver 2008.Memberregistrationand login
procedures(WebSecurity.CreateAccountWebSecurity.Login),E-mailat the
"i"isthe problemexists.Unable to createa password.existingmemberscan not log
in.but theemailaddress of the"i"does not include thetime
no problem.serversoftwarein English.Turkish
regionalsettings.
I wonderwhat's the problem?
System.Web.Security.MembershipCreateUserException: The Provider encountered an unknown error. at WebMatrix.WebData.SimpleMembershipProvider.CreateAccount(String userName, String password, Boolean requireConfirmationToken) at WebMatrix.WebData.WebSecurity.CreateAccount(String
userName, String password, Boolean requireConfirmationToken) at System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) at
Now, there is a problem with characters I & I-dotted. Username with these characters is not found in your Membership functions. Our investigation shows
that sql statements' parameters in your Membership conversions are correct. The problem comes from database where lower function does not return correct characters.
if i use replace function for email, user is forced to enter with the "İ" character. ( if user name is "info" user should enter "İnfo" i dont want this)
is there an easy way ?
i changed collation of sql server but nothing happened.
blackseacode...
Member
110 Points
65 Posts
Sqlserver 2008 and Websecurity
Aug 31, 2011 07:57 AM|LINK
Hello. am using sql server 2008. Member registration and login procedures (WebSecurity.CreateAccount WebSecurity.Login), E-mail at the "i" is the problem exists. Unable to create a password. existing members can not log in. but the email address of the "i" does not include the time no problem. server software in English. Turkish regional settings. I wonder what's the problem?
blackseacode...
Member
110 Points
65 Posts
Re: Sqlserver 2008 and Websecurity
Aug 31, 2011 01:59 PM|LINK
Mikesdotnetting help me pls
simtan
Member
592 Points
91 Posts
Re: Sqlserver 2008 and Websecurity
Sep 02, 2011 11:37 AM|LINK
Sorry, you may have to rephrase your question... it is not clear what the problem is.
Program Manager
Web Platform and Tools
blackseacode...
Member
110 Points
65 Posts
Re: Sqlserver 2008 and Websecurity
Sep 02, 2011 02:51 PM|LINK
Mikesdotnett...
All-Star
155593 Points
19979 Posts
Moderator
MVP
Re: Sqlserver 2008 and Websecurity
Sep 02, 2011 03:29 PM|LINK
Are you saying that the lower case "i" is not recognised by SQL Server? If so, is this your problem: http://stackoverflow.com/questions/780671/problems-with-turkish-sql-collation-classic-i-problem?
Web Pages CMS | My Site | Twitter
blackseacode...
Member
110 Points
65 Posts
Re: Sqlserver 2008 and Websecurity
Sep 03, 2011 07:41 AM|LINK
thanks everybody
blackseacode...
Member
110 Points
65 Posts
Re: Sqlserver 2008 and Websecurity
Sep 03, 2011 11:41 AM|LINK
System.Web.Security.MembershipCreateUserException: The Provider encountered an unknown error. at WebMatrix.WebData.SimpleMembershipProvider.CreateAccount(String userName, String password, Boolean requireConfirmationToken) at WebMatrix.WebData.WebSecurity.CreateAccount(String userName, String password, Boolean requireConfirmationToken) at System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) at
blackseacode...
Member
110 Points
65 Posts
Re: Sqlserver 2008 and Websecurity
Sep 03, 2011 12:19 PM|LINK
Now, there is a problem with characters I & I-dotted. Username with these characters is not found in your Membership functions. Our investigation shows
that sql statements' parameters in your Membership conversions are correct. The problem comes from database where lower function does not return correct characters.
WebSecurity.CreateAccount(mail.Replace("i", "İ"), pass, act)
bilencekic
Member
126 Points
54 Posts
Re: Sqlserver 2008 and Websecurity
Jan 09, 2013 09:47 PM|LINK
same problem please help!.
if i use replace function for email, user is forced to enter with the "İ" character. ( if user name is "info" user should enter "İnfo" i dont want this)
is there an easy way ?
i changed collation of sql server but nothing happened.