The setting for the database and the tables is:
collation: cp1250_general_ci
characterset: cp1250
Here is an example with the german word for the french language:
-}new
-}open(1,iol=*)"data/gd/sgb03"
-}?pth(1)
[MYSQL]koss;gd03_sgb
-}?opt(1)
server=srvr;user=me;pswd=Passwort;prepare=0;concurrency=OPT_
VALUE;extropt=$ for update;timeout=1;cursorclose=YES;cursor_type=DYNAMIC;isolati
on=COMMITED;autocommit=ON;nonumadj=Y;KEY=sgb_nr;REC=sgb_nr:1+sgb_bez:25+iac,iac3
,monat_l01,monat_l02,monat_l03,monat_l04,monat_l05,monat_l06,monat_l07,monat_l08
,monat_l09,monat_l10,monat_l11,monat_l12,monat_k01,monat_k02,monat_k03,monat_k04
,monat_k05,monat_k06,monat_k07,monat_k08,monat_k09,monat_k10,monat_k11,monat_k12
,tag_l1,tag_l2,tag_l3,tag_l4,tag_l5,tag_l6,tag_l7,tag_k1,tag_k2,tag_k3,tag_k4,ta
g_k5,tag_k6,tag_k7
-}dim sgb$:iol(1)
-}sgb.sgb_nr$="3"
-}sgb.sgb_bez$="Französisch"
-}write record(1)sgb$
-}read record(1,key="3")sgb$
-}?sgb.sgb_bez$
Franz?sisch