Encoding utf-8 with sqlite

[serch87]

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:

 

[Erel]

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.

 

[serch87]

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.