Also looking for MSSQL integration person

Skip Kimpel skiplondon at gmail.com
Mon Jul 26 18:57:24 EDT 2021


Actually, just looked and another field that is nchar(10) is also receiving
the "?" result so it has nothing to do with the "max" parameter.


SKIP

On Mon, Jul 26, 2021 at 6:54 PM Skip Kimpel <skiplondon at gmail.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
>
> 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
>>
>



More information about the use-livecode mailing list