revDataFromQuery and umlauts etc.

[Christian Langers]

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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution