password limitations in SQL Server and MySql
Posted
by asteroid
on Stack Overflow
See other posts from Stack Overflow
or by asteroid
Published on 2010-01-08T20:45:01Z
Indexed on
2010/05/30
20:02 UTC
Read the original article
Hit count: 142
Does MySql 5.1 and SQL Server 2008 (Web edition, Standard) have any functional password limitations other than length limits? Are metacharacters in any form a bad idea to use, like bang, pipe, hash, any slash, carrot, and so on?
I know that MySql 5.1 has a password length limitation of 16 characters that is hardcoded, but I was wondering, are any metacharacters (i.e. non alphanumerics) a bad idea to use? And is this true in SQL Server 2008 Web edition, Standard?
So specifically: can symbols like:
/`~>:}{[]^ be used successfully?
I would hope it doesn't matter to the database, but I don't understand enough about password storage in enterprise database systems yet to know for sure, and I was looking for confirmation or an explanation.
© Stack Overflow or respective owner