Encoding/Decoding and SQL

[alexandernst]

I have a MySQL database and I'm trying to insert some spanish symbols (like ñ), but then I try to show them
back to a textbox and I get some weird symbols (encoding/decoding problem).

What's the right way for inserting and retrieving data to/from database?

Thanks