Problems with text data fields pulling from SQL

Paul Dupuis paul at researchware.com
Wed May 12 10:11:26 EDT 2021


Possibly an encoding issue? If the text in the database was in Unicode 
or some non-ASCII encoding, then it may appear as one or more question 
marks in LC unless textEncode/textDecode (I forget which would apply) is 
used to translate it from the database encoding


On 5/12/2021 9:38 AM, Skip Kimpel via use-livecode wrote:
> I am pulling data from an Azure MS SQL database using an ODBC connection.
> All data comes across just fine EXCEPT for data with field types of
> NVARCHAR(Max).
>
> When those fields arrive to LC, it shows up as a question mark "?".
>
> Any reason why this would happen?   Any resolution to this?
>
> Best regards,
>
> 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





More information about the use-livecode mailing list