Working with tab data and utf-8
bobs at twft.com
Tue Oct 25 11:51:27 CDT 2011
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.
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"
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode