Using passwords with SHA256

I have a user register form, which works absolutely fine when using a text password.
However as soon as I add SHA256 onto the password inserted into the database, when you try and log on it gives unauthorised using the password.
Is there something on the login password field I need to add so it knows that its SHA256 ? or am I barking up the wrong tree?