Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2006-06-20 : 02:08:19
|
| hi All,just wondering, we never guarded againsts spaces in a new site we built.And while checking, a couple of users registered with spaces between their usernames.e.g. afrika 1 instead of afrika_1 Could there be downside to this ?Afrika |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-06-20 : 02:25:24
|
| For now you can do one 2 things1) Change the user name by replacing space with "_" and inform the users.2) Else replace space with "_" in user name but on the other hand while login in let the user enter space in it. But while comparing replace space with "_". Also put a check in ur application where new users register, so that the users are not allowed to punch in user name with space.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-20 : 03:54:08
|
no downside AFAIK since the space will be treated as a character --------------------keeping it simple... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-20 : 17:17:51
|
| We don't allow it. All our "natural PKs" have A-Z, 0-9 and "_" only.We never used to worry with Windows APPs but: o Users forget they put a space in o URLs containing the data are problematic.Kristen |
|
|
|
|
|
|
spaces between username