If it helps, I use InnoDB and my encoding is utf8_general_ci. That's probably not good for unicode though. I don't localize my app, it's just for use here at work.
Bob S > On Jul 26, 2021, at 13:59 , Paul Dupuis via use-livecode > <use-livecode@lists.runrev.com> wrote: > > I can't help you figure it out, but text coming through as questions marks is > almost always and text encoding issue. > > For example, if the text is stored in the mySQL database as UTF8, then after > fetching it in LiveCode nd before placing it in a field, you need to > textDecode(<the variable with the text>,"UTF8") (see the textDecode > dictionary entry) > > If you are going the other way, text entered into a LiveCode field needs to > be textEncode(<field text>,"UTF") before storing in the database. > > You need to either look up what encoding you table(s) are using or set the > encoding of the table(s) in the database to what you want and then perform > the appropriate textEncode or textDecode operations in LC > > > > On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote: >> I have MSSQL data flowing into my project but two data input fields are >> coming through as "?" instead of the actual text. >> >> WIlling to pay someone to help me figure this out. >> >> Please contact me directly at s...@magicgate.com >> >> >> Thank you! >> >> SKIP >> _______________________________________________ >> 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 > > > _______________________________________________ > 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 _______________________________________________ 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
