Re: Problems with text data fields pulling from SQL

2021-05-13 Thread Ben Rubinstein via use-livecode
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

Re: Problems with text data fields pulling from SQL

2021-05-12 Thread Paul Dupuis via use-livecode
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