Re: Database data & emoji's

2018-08-14 Thread Stephen MacLean via use-livecode
Unfortunately, this looks to be an issue with the revDatabaseColumnNamed() not getting the proper data, even when using a variable in the command to get binary data: put revDatabaseColumnNamed(sRecSet,"tw_full_text","test”) <- should get either text or binary data with put test into fld "clea

Re: Database data & emoji's

2018-08-14 Thread Stephen MacLean via use-livecode
Hi Tore, Thanks, but I’ve already looked at and tried those. Even putting the data directly from the RecordSet to the field just results in question marks “?” where the emoji should be: put textDecode(revDatabaseColumnNamed(sRecSet,"tw_full_text")) into fld "cleaned_tw_content" of cd “twClean

Re: Database data & emoji's

2018-08-14 Thread Tore Nilsen via use-livecode
You should look up textEncode and textDecode in the dictionary. I think they may prove useful. Best regards Tore Nilsen --- This mail contains no viruses or bacteria as it is electronically produced and untouched by human hands. Once printed it may or may not contain various microorganisms