Working with tab data and utf-8

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