Damn You Unicode!

[Bob Sneidar]

Actually it looks like this is happening internally to sqlYoga. I think it’s because I am querying a SQL Server. This doesn’t happen with a mySQL database. 

Bob S

> On Apr 14, 2020, at 12:56 PM, Bob Sneidar <bobsneidar at iotecdigital.com> wrote:
> 
> I have some code in a field that I put into a variable then I “do” the variable. Works fine on a Mac. On Windows however, the command throws an error. 
> 
> I build the code in the field by getting values from different objects on the card. In this particular case, I am getting the dgProp [“columns”] of a data grid. 
> 
> The problem then is that text is unicode, so when I attempt to do the code, it fails, and the error indicates that the last character of the code is the first character of the dgProp [“columns”]. 
> 
> Example:
> 
> sqlquery_set qObject, “select clause”, “E
> 
> That is as much as sqlYoga sees of the command because what comes after is the second byte of the letter “E” in all it’s unicode glory. 
> 
> So how do I completely remove any unicode from text in a field? I am already getting the text of the field. I have already tried textEncode and textDecode using ASCII, UTF-8. I end up with the same string containing unicode. 
> 
> Bob S
>