Problems with text data fields pulling from SQL

[Ben Rubinstein]

This. NVARCHAR is for Unicode strings.

You may be able to deal with it by modifying the ODBC DSN or the query to do a 
conversion before it reaches LiveCode.

Otherwise, IIRC you need to use revDatabaseColumnNumbered and go row by row 
(rather than revDataFromQuery); taking the data and using textDecode to get it 
out of (probably) UTF-8.

Some experimentation may be needed!

Ben


On 12/05/2021 15:11, Paul Dupuis via use-livecode wrote:
> 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
> 
> 
> _______________________________________________
> 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