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 On Mon, Jul 26, 2021 at 5:01 PM Paul Dupuis via use-livecode < [email protected]> wrote: > I can't help you figure it out, but text coming through as questions > marks is almost always and text encoding issue. > > For example, if the text is stored in the mySQL database as UTF8, then > after fetching it in LiveCode nd before placing it in a field, you need > to textDecode(<the variable with the text>,"UTF8") (see the textDecode > dictionary entry) > > If you are going the other way, text entered into a LiveCode field needs > to be textEncode(<field text>,"UTF") before storing in the database. > > You need to either look up what encoding you table(s) are using or set > the encoding of the table(s) in the database to what you want and then > perform the appropriate textEncode or textDecode operations in LC > > > > On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote: > > I have MSSQL data flowing into my project but two data input fields are > > coming through as "?" instead of the actual text. > > > > WIlling to pay someone to help me figure this out. > > > > Please contact me directly at [email protected] > > > > > > Thank you! > > > > 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
