It would be nice to have the following, additional properties for the TextBox: bold italic and for file open: cASCII already exists, but Ansi and UTF-16 left. Best Regards berndgoedecke
Ansi and UTF-16 and what is about Ansi and UTF-16 - file open Or is there an other way or Lib to convert to UTF-8. It's because of the UTF-16 encoded SQLite Dtabase. Showing datas in the textbox let fail the special letters like "ä" "ö" "ü" etc.
It is possible to convert a complete file from UTF-16 to UTF-8 (using BinaryFile and Bitwise libraries). However, if this is a database file you can't treat it as a text file. Please try the following connection string: Con.Open("Data Source = " & AppPath & "\Northwind.sl3;UseUTF16Encoding=True") Replace the database name with your database file.
I feel like I am missing something here. "It's because of the UTF-16 encoded SQLite Dtabase. Showing datas in the textbox let fail the special letters like "ä" "ö" "ü" etc." I can enter ö, ä, å etc in a textbox, store that in a SQLite database and close the program, open it again and retrieve the letters to a textbox (via a table) without any problems and without using the "UseUTF16Encoding=True". all the best / Björn
Basic4ppc uses UTF-8 by default. UTF-8 supports all characters. UseUTF16Encoding should be used when you get a database that you didn't create (at least not with Basic4ppc) and it is encoded with UTF-16.