Also looking for MSSQL integration person

Bob Sneidar bobsneidar at iotecdigital.com
Mon Jul 26 17:25:23 EDT 2021


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 at 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 skip at magicgate.com
>> 
>> 
>> Thank you!
>> 
>> SKIP
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list