Password with blank space

[quincia]

Hello everybody,

sorry for my poor english!!

So, i've implemented an authentication service with package Auth.

In the DB the passwords are stored in a table with a column named 'Password' of nvarchar(20).

So, I've an user quincia and password pippo.

When I insert the user quincia and the password 'pippo' the login fail but when I insert user quincia and the password 'pippo' with 15 blank space the login is correct!! Why!!!

In fact, the column in the db have 15 blank space but when I do a

"SELECT from TBUSER where Password='pippo' give back a RecordSet

Thank you very much for help

Umbe