White diamond with a question mark in the middle

[anaylor01]

I have a label that is loaded with text from a csv file. Every once in a while there are white diamonds with questions marks in the middle(see attached screen shot) that show up. I looked at the raw data and cannot see why this is happening.

 

[Erel]

Can you post your data file and the code that shows the text?

 

[anaylor01]

Here is a data line.
80|Which*professional*sport*awards the Lady Byng Memorial Trophy each year for the Most Gentlemanly Player?|NHL|NFL|PGA|NBA|Sport|3

Here is the code:
question = SQL1.ExecQuerySingleResult2("SELECT question FROM trivia where ID = ? and category = ?",Array As String(NewNumber,category))

lblQuestion.Text = question

 

[anaylor01]

WHOA... where did those asterisks come from?

 

[anaylor01]

When I paste that data in other text related stuff the asterisks don't show up. It doesn't show up when I paste it only after it has been posted.
80|Which*professional*sport*awards the Lady Byng Memorial Trophy each year for the Most Gentlemanly Player?|NHL|NFL|PGA|NBA|Sport|3

 

[Erel]

The asterisks are converted to the diamonds. The text stored in the database probably includes some illegal characters. Maybe because of wrong encoding.

Try to open the database with any SQLite viewer and check the values stored.

 

[anaylor01]

I used Sqlite expert professional to import the text file and everything looks fine. How do I view the database created with B4A?

 

[anaylor01]

Attached is a txt file with a line that has 5 white diamond question marks. I can't find anything that shows it except here and in B4A.
203|Which*street in London*takes its name from the*ornamental collars once*made by the* 17th century tailor Robert Baker?|Piccadilly|Pall Mall|Threadneedle|Carnaby|Geography|3

 

[agraham]

Where the asterisks show the bytes in the file are value 0xA0 instead of the expected 0x20 so it looks like your database has some duff characters in it.

 

[anaylor01]

Whew. Ok. Had to convert from ISO 8991-1 to UTF 8.