textencoding for MySQL DB

[Klaus major-k]

Hi all,

> Am 29.07.2025 um 16:16 schrieb Klaus major-k via use-livecode <use-livecode at lists.runrev.com>:
> 
> 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 :-/

the reason for this was "Internet" not checked in the STAB for Android. 8-)
Now i works with:
...
put fld "username" into tUsername
...

Isn't everything in LC UTF8? 
Obviously not, so there would not be these differences, right?

Anyway, problem solved, thank you!


Best

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