textencoding for MySQL DB

[Klaus major-k]

Hi friends,

my student has set up an online mySQL database on his PC.
The DB rtextencoding is: utf8mb4 (whatever that may be :-)
Now we are creating GUI for mobile.

One problem are (still and again) UMLAUTS!? :-/

We have a testuser named könig (king in german) and it works
if you log on to the db on a Windows PC but on my Mac I got
"unknown user". OK.

So I tried on my Mac:
...
put textencode(fld "username","UTF-8") into tUsername
## I got : unknown user :-/
...

So I tried:
...
put mactoiso(fld "username") into tUsername
## And I could log into the DB
...
I thought mactoiso would have been deprecated, but then I could not get
textencode(what,how) to get the fiúnctionality of mactoiso but failed?

Then I tried this on an Android device:
...
put fld "username" into tUsername
## I got : unknown user :-/
...
Could not try on iOS yet.

So my question, how should I encode my usernames on iOS and Android
to be able to log-in to the online mySQL DB?

Thanks for any hint!


Best

Klaus
--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
klaus at major-k.de