Problem with UTF-8 Encoding on SQLCE

Question

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 "ñ" and "Ñ", 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.

Answer 1

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" />