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 character set encoding in your SQL tables that will accommodate the language you are storing. I do not have a lot of experience in the matter, but I will bet that a search of the list archives will turn up you solution pretty quickly.
Bob On Oct 25, 2011, at 9: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 variable theData > > 2 123456789 Empresa 2 Empresa 2 Dirección 2 Mucia Murcia > 30001 España 868987654 868987654 > > now, I need the second value. How can I get it? > > I tried with > set the text of field "cif" of group "controles empresa" to the second > column of theData > > But I get a syntax Error. > > Another problem I have is with ¿utf8? > > In database, the fifth column with "Dirección 2" in database is "Dirección 2" > > Regards. > > _______________________________________________ > 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 _______________________________________________ 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
