Problem with UTF-8 Encoding on SQLCE

I'm using SQLCE for a database on a local application, I set that the encoding would be UTF-8, this encoding is supposed to accept the "ñ" an开发者_运维百科d "Ñ", but when I save "españa" and after that I do a query to see all the tuples on the table, it shows "espa�a" with that weird replacement character. I was wondering if there's any way I could correct this.

update: it seems that it's because my SO is English, and the database get that config.

Check your SQL Studio (if that's where you query that table) settings for the proper encoding of the displayed data, as sometimes your regional settings mess the things a bit.

If you're displaying the result in a web application, use this:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />