PureBasic Forums - English

To see which characters PureBasic gives to the SQLite-database (PostgreSQL is the same)

Define char$, i.w, string.s=""
Define DatabaseFile.s = GetCurrentDirectory()+"Database.sqlite"

UseSQLiteDatabase()

OpenWindow(0, 0, 0, 300, 300, "", #PB_Window_SystemMenu)
StringGadget(1, 10, 10, 200, 20 ...

GetDatabaseString() correctly support UTF8, the euro sign isn't part of ASCII table as Danilo said, that's why it fails in ASCII mode. If you want to be on the safe side regarding non-ascii literal characters, you need to compile in unicode mode.

But why do you convert the characters chr(128)-chr ...

I think, the best solution for the problem is to change DatabaseUpdate, so that it works under unicode-off like
GetDatabaseString works - in unicode-off. This way all peaple, who are using PB 5.00 or prior unicode-off-executable,
can be updated to PB 5.21 unicode-off-executable without loosing some ...

As I have written in my first posting, you can read characters like € with unicode executable correctly, even if they
were written with unicode-off executable. PB unicode-off gives the wright character to database (not only "?"), but in unicode, because you read "€" with unicode-on, not "?". The ...

The problem is, that PB 5.10 and greater is not able to read carachters like € from databases, thas it itself
had written with unicode-off-executable. It reads only an ?.
With PB 5.00 or prior it was possible to write € and to read €.

Try this code with PB 5.00 unicode-off and with PB 5.10-5.21 ...

From PureBasic version 5.10 i it is not possible to use additional characters like "€" in databases PostrgeSQL and SQLite, if the executable is not compiled in unicode.
I think, DatabaseUpdate writes to the databases in unicode, even if the executable is compiled in non-unicode, because i can read ...