I get the same results when using SQLite Database Browser to insert data with umlauts and retrieving it from within Rev ; fortunately my app inserts data into the DB, and therefore I can encode the data to the ISO-Format and back to MAC-Format when I need the data. That's working for me and I only need 2 functions ;-)

function SQLTextEncodingToMyApp pString
  switch platform()
    case "MacOS"
      return isotomac(pString)
      break

    case "Win32"
      return pString
      break
  end switch
end SQLTextEncodingToRaj

------------------------------

function MyAppTextEncodingToSQL pString
  switch platform()
    case "MacOS"
      return mactoiso(pString)
      break

    case "Win32"
      return pString
      break
  end switch
end RajTextEncodingToSQL        



Christian




Le 20 mai 08 à 11:31, Ian Wood a écrit :


On 20 May 2008, at 10:17, Christian Langers wrote:

I think you're right...

My solution is to use the MacToIso() function for inserting data into the db (from within Revolution) and applying the IsoToMac() function to the data you retrieved from the SQLite Db....

I'm pretty sure it's an encoding problem, but ISOToMac on the returned data gets me:
ä
ü
ë
ö
ï
â
û
ô
ê
î
Â¥
aÌ
Ë™
â
©
`a
∆

Closer, but still garbage.

I really don't want to rewrite ~50 functions to use shell commands... :-(

Ian_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to