Encoding utf-8 with sqlite

Hi everyone, my question is how show the queries on SQLite with data like the letter "ñ" in the textboxes for example I have "Yañes" and in the texbox appear "Ya?es" people in the other forum say me that is a encoding problem but I don't know how resolve this situation I'm new in this languaje(Basi4ppc) and database SQLite I just need to show records but the all transactions are do in PHP with MySQL (INSERT and DELETE) the application only use it to display data.(sorry for my bad english)

I hope someone help me


SERGIO.


:sign0085:

First make sure that the device supports this character by displaying it in a TextBox.

I guess that the data was inserted with an encoding other than UTF8. You can try to open it with some other tool.

Hi everyone, after investigated about encoding in the languajes that I use for my aplication, I found the error that is the way to insert data from PHP to SQLite passed from MySQL.
I resolved the problem using the encoding UTF-8 in the queries of MySQL for after insert into SQLite.

Thanks everyone for your help and the patience for me.



SERGIO.