Also looking for MSSQL integration person

[Skip Kimpel]

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 <
use-livecode at lists.runrev.com> 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 skip at magicgate.com
> >
> >
> > Thank you!
> >
> > 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
>