Re: Working with tab data and utf-8

2011-10-25 Thread Bob Sneidar
There have been quite a bit of posts in the past about storing data in non-english languages that use extended character sets. One solution is to store the HTMLtext of a field, and set the contents of a field to the results from a query. Not sure if that will work for you. Another is to use a ch

Re: Working with tab data and utf-8

2011-10-25 Thread Mark Schonewille
Hi Giuseppe, For plain text, you can use: set the itemDel to tab put item 2 of theData into field "cif" of group "controles empresa" I'm not sure that the UTF8 returned by MySQL is read correctly by LiveCode. If LiveCode reads it correctly, you can do: set the unicodeText of fld "cif" of grp "

Re: Working with tab data and utf-8

2011-10-25 Thread Devin Asay
On Oct 25, 2011, at 10:37 AM, Giuseppe wrote: > Hi all, > > I'm having a little problem I don't understand. > > With this code > put "SELECT * from empresas WHERE nif = '" & pID & "'" into theSQL > put revDataFromQuery(tab, cr, sDatabaseID, theSQL) into theData > > I get this in a vari

Re: Working with tab data and utf-8

2011-10-25 Thread Klaus on-rev
Buonasera Giuseppe, Am 25.10.2011 um 18:37 schrieb Giuseppe: > Hi all, > > I'm having a little problem I don't understand. > > With this code > put "SELECT * from empresas WHERE nif = '" & pID & "'" into theSQL > put revDataFromQuery(tab, cr, sDatabaseID, theSQL) into theData > I get th

Working with tab data and utf-8

2011-10-25 Thread Giuseppe
Hi all, I'm having a little problem I don't understand. With this code put "SELECT * from empresas WHERE nif = '" & pID & "'" into theSQL put revDataFromQuery(tab, cr, sDatabaseID, theSQL) into theData I get this in a variable theData 2123456789Empresa 2Empresa 2Direc