Re: Field retrieved from a Mongo document display wrong characters
I agree. The document oriented format is a nice match for livecode arrays. I have used mongodb (from mongolab.com) quite a bit (albiet over an http interface of some kind). I had good experiences with it, save for livecode's blocking url commands causing me some fuss. Regards, Andrew K On Wed, Sep 24, 2014 at 4:04 AM, Javier Miranda wrote: > Dear Jacqueline, thank you for your help. In Mongo everything is UTF-8, > converting the string returned by the server to UTF-16 worked perfectly. > Let me add that I see great potential using LiveCode as a front end to > Mongo. > > Saludos, > > Javier Miranda V. > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Regards, Andrew Kluthe and...@ctech.me ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Field retrieved from a Mongo document display wrong characters
Dear Jacqueline, thank you for your help. In Mongo everything is UTF-8, converting the string returned by the server to UTF-16 worked perfectly. Let me add that I see great potential using LiveCode as a front end to Mongo. Saludos, Javier Miranda V. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: Field retrieved from a Mongo document display wrong characters
On 9/19/2014, 4:42 PM, Javier Miranda wrote: I have a local Mongo Server and a LiveCode Stack to work as front end to it. When I enter "Se cambiarán los bornes" (please note the accent), in a LiveCode field, the text is properly shown, inserting it as a document to a Mongo collection also works fine, the field is saved OK in the document. I can see it using the Shell. The problem is that, when I retrieve the document back to LiveCode, the field receiving the field shows: "Se cambiarÃan los bornes". Trying to find the reason I found that the encoding of field "resul" , the field receiving the accented string is Native. Can you help finding the way to make this strings show the right characters? I don't know anything about Mongo, but if it is sending back UTF8, then you need to convert it to UTF16: function convertFromUTF8 pString -- convert a server UTF8 string to LC return unidecode(uniencode(pString,"UTF8")) end convertFromUTF8 -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Field retrieved from a Mongo document display wrong characters
I have a local Mongo Server and a LiveCode Stack to work as front end to it. When I enter "Se cambiarán los bornes" (please note the accent), in a LiveCode field, the text is properly shown, inserting it as a document to a Mongo collection also works fine, the field is saved OK in the document. I can see it using the Shell. The problem is that, when I retrieve the document back to LiveCode, the field receiving the field shows: "Se cambiarÃan los bornes". Trying to find the reason I found that the encoding of field "resul" , the field receiving the accented string is Native. Can you help finding the way to make this strings show the right characters? The code in the button retrieving the document from mongo is: on mouseUp local theMongo, theDB, dbText, theCole, thePreg, theQuerry put empty into field resul put "C:\mongodb\bin\mongo.exe localhost:27017/" into theMongo put "BatGar" into theDB put "BatRegis"into theCole put "'" & field F1 & "'" into toFind put "{"& quote & "_id" & quote & ":" & toFind & "}" into thePreg put "; printjson(db.getLastError())" into dbErr put ".find(" & thePreg & ");"into theQuerry put "var c=db."& theCole & theQuerry into dbText put " while(c.hasNext())" after dbText put " printjson(c.next())" after dbText put dbErr after dbText put theMongo & theDB && "--eval" && quote & dbText & quote into dbText1 put shell ( quote &dbText1 & quote) into dbResultado put the number of lines of dbResultado into nro put line 3 to (nro - 1) of dbResultado into field resul if field resul is empty then Answer warning "El Documento NO ha sido encontrado. El sistema no tiene registrada una Batería con el ID: " & field F1 with OK else Answer warning "El Documento ha sido encontrado, ID: " & field F1 with OK end if end mouseUp Saludos, Javier ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode