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 :)