Page 1 of 1
german umlaute
Posted: Wed Jul 13, 2011 7:50 pm
by fredigertsch
Is it realiy true? does runrev not work with german umlauts? I have in a Database german words as "Schriftart wählen" etc. When I read this records in a runrev query I get "Schriftart wählen". Any help? Thank you.
Fredi
Re: german umlaute
Posted: Wed Jul 13, 2011 10:16 pm
by dunbarx
I am probably out of my depth, but ASCII 159 and unicode 00FC both produce this character.
Craig Newman
Re: german umlaute
Posted: Wed Jul 13, 2011 10:33 pm
by Klaus
Hi Fred,
what encoding is being used in your database?
I guess that internally all text will be treated a ISO, so on the Mac you will see this inconvenience!
Try to convert your text to iso
-> mactosio("your text here") BEFORE writing to the database and convert back
-> isotomac(...) after you retrieved data from the database and BEFORE you put this into any field.
Something like this:
Code: Select all
...
if the platform = "MacOS" then
put mactoiso(...)...
end if
...
Best
Klaus
Best
Klaus
Re: german umlaute
Posted: Wed Jul 13, 2011 10:53 pm
by BvG
looks more like utf8 to me. try these two functions at the appropriate places:
Code: Select all
function createUtf8Text theText
return unidecode(uniencode(theText),"utf8")
end createUtf8Text
function getRevTextFromUTF8 theText
return unidecode(uniencode(theText,"utf8"))
end getRevTextFromUTF8
Re: german umlaute
Posted: Thu Jul 14, 2011 8:59 am
by fredigertsch
Thank you to all, i will try and report it.
Re: german umlaute
Posted: Fri Jul 29, 2011 7:37 pm
by fredigertsch
Hi BvG
Your function does work:
function getRevTextFromUTF8 theText
return unidecode(uniencode(theText,"utf8"))
end getRevTextFromUTF8
but only without the 8 in the function-name.
THANK YOU
Re: german umlaute
Posted: Sat Jun 15, 2013 7:47 am
by fredigertsch
Hi there
Now I have a new problem like this - i work now with mac
When I save a string like this "Wir gehen in der Küche Brot holen" in a sqllite database, then the string is after the umlaut ü broken. In the database is only saved "Wir gehen in der K". Thanks for any help.
Fredi
Re: german umlaute
Posted: Sat Jun 15, 2013 8:14 pm
by fredigertsch
I found it: because I work now with mac it is: put ISOtoMac(tTextzeile1) into tTextzeile1
Thanks all Readers
Re: german umlaute
Posted: Fri Jul 05, 2013 8:57 pm
by trenatos
I'm working with Swedish characters (åäö) and this helped me out too
