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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to