Character encodings back and forth

Which is the most transparent way to handle character encodings in
your experience? For a small internal application in Spanish I was
going to go with everything in UTF-8, database and views. Does that
work smooth in your experience? How do you handle the encoding of
input coming from forms?

– fxn