german umlaute

[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

[dunbarx]

I am probably out of my depth, but ASCII 159 and unicode 00FC both produce this character.

Craig Newman

[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

[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

[fredigertsch]

Thank you to all, i will try and report it.

[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

[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

[fredigertsch]

I found it: because I work now with mac it is: put ISOtoMac(tTextzeile1) into tTextzeile1
Thanks all Readers

[trenatos]

I'm working with Swedish characters (åäö) and this helped me out too