Re: Damn You Unicode!
I’m thinking that possibly there is a violated assumption as to what the other end is using within that, yes. Or that the other end makes an assumption, and puts the “wrong” type back in. Which kind of SQL server is that? Microsofts? I can probably rig access to my Postgres server if you need to try it for a test case. (It would probably do me good to remember how that works :) ___ 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
Re: Damn You Unicode!
On 4/14/20 2:34 PM, doc hawk via use-livecode wrote: Mark mentioned Try a picnic basket instead Given that someone actually implemented RFC 1149, why not? Ha! I totally missed the fact that someone (other than Terry Pratchett) had actually done a real-world implementation. "And, as usual among Linux groupies, Microsoft took some of the heat. One pigeon bonked into a nearby window, spurring Cox to quip, "Oh, no! Windows causing problems again," Engen said." https://www.cnet.com/news/pigeon-powered-internet-takes-flight/ -- Mark Wieder ahsoftw...@gmail.com ___ 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
Re: Damn You Unicode!
Mark mumbled > and in doing so you could unUnicode it. OK I made up that word, but still… Verbing nouns again, the man is . . . ___ 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
Re: Damn You Unicode!
On 4/14/20 12:56 PM, Bob Sneidar via use-livecode 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. don't know sqlyoga, but aren't you setting yourself up for sqlinjection? Would suggest you at least scrub the data first before executing it. And in doing so you could unUnicode it. OK I made up that word, but still... -- Mark Wieder ahsoftw...@gmail.com ___ 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
Re: Damn You Unicode!
Mark mentioned > > Try a picnic basket instead Given that someone actually implemented RFC 1149, why not? ___ 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
Re: Damn You Unicode!
On 4/14/20 1:09 PM, doc hawk via use-livecode wrote: Shooting from the hip, but could it be differences in cr, lf, and the like getting processed differently? That is, being intrereted by your yogi as a break in one implementation and not another? (Which, of course, would be a boo-boo.) pawk, who couldn’t manage to get “Cindy” or “ranger smith” into the last paragraph . . . Try a picnic basket instead -- Mark Wieder ahsoftw...@gmail.com ___ 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
Re: Damn You Unicode!
Shooting from the hip, but could it be differences in cr, lf, and the like getting processed differently? That is, being intrereted by your yogi as a break in one implementation and not another? (Which, of course, would be a boo-boo.) pawk, who couldn’t manage to get “Cindy” or “ranger smith” into the last paragraph . . . ___ 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
Re: Damn You Unicode!
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 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 > ___ 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
Damn You Unicode!
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 ___ 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