MAX is the argument for maximum VARCHAR size. SQL Server NVARCHAR data type is used to store variable-length, Unicode string data.
MSSQL has a try_cast snf cast function. Try using that to have the SQL server convert the data into VARCHAR and see what you get. Bob S > On Jul 26, 2021, at 15:54 , Skip Kimpel via use-livecode > <use-livecode@lists.runrev.com> wrote: > > I think it is how I have everything setup.... something is getting lost in > translation. Keep in mind it is only two fields I am getting the "?" > results back instead of the text contained inside. The MSSQL data types of > those two fields are: nvarchar(max). Interestingly enough, I have other > nvarchar fields coming through just fine but the difference is the "(max)" > piece. > > It is a Azure SQL server and because I have not been able to figure out how > to do a direct connection to it, I am using an ODBC connector with > 32/64-bit ODBC Driver 13 for SQL server. > > Does this help at all? I went through all the encoding types but they all > failed using the textEncode.... when I say fail, I mean not the desired > result. > > Maybe I hone in on the "max" piece of that code?? > > > SKIP _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
