Vici coolstorage text fields not showing properly in WP7 app (some characters missing)

Question

I have a sqlite database that I access from my WP7 app using the coolstorage ORM. The charset used for the text fields of the db (which are in German) is UTF-8. The database is quite simple and only has one table. My model in the app looks something like this:

[MapTo("recipes")]
public class Recipe : CSObject<Recipe,int>
{
    [DefaultSort]
    public int Id
    {
        get { return (int)GetField("Id");  }
    }

    public string Category
    {
        get { return (string)GetField("Category"); }
        set { SetField("Category", value); }
    }

    // More text fields

And then I fetch a row from the db by doing the following:

rec = Recipe.ReadFirst("Category=@Category and Name=@Name",
                                 "@Category", category,
                                 "@Name", recipe);

The problem is that all the special German characters show up like this: �, even though they're properly stored on the db. All the normal ASCII characters show up just fine.

How can I solve this? Thanks in advance.

Answer 1

You might want to look at this http://msdn.microsoft.com/en-us/library/7b93s42f.aspx