Special Characters in Passwords

I find a lot of how-to's with security and passwords.  What I need to know is if there are restrictions in what types of characters can be used in good old plain text passwords?  For example, if we set a password connection to a database in the 8-ds.xml file to Jbo$$is@llRight#  why would it fail?  Should it work?