Accessing 'ntext' fields from SQL Server over ODBC (Windows)

Ben Rubinstein benr_mc at cogapp.com
Wed Jan 12 09:53:01 EST 2011


Hi Andre,

Tried it, no success.

Thanks,

Ben

On 12/01/2011 13:55, Andre Garzia wrote:
> Ben,
>
> have you tried the select with the substring?
>
> andre
>
> On Wed, Jan 12, 2011 at 11:41 AM, Ben Rubinstein<benr_mc at cogapp.com>  wrote:
>> Thanks Andre.  However, the size of these fields is not that great -
>> probably less than 1K - and in our test database it's just a few bytes.
>>
>> Has anyone else experience with accessing ntext fields from SQL Server over
>> ODBC - using Rev/LiveCode or anything else?
>>
>> TIA,
>>
>> Ben
>>
>> On 12/01/2011 13:17, Andre Garzia wrote:
>>>
>>> Ben,
>>>
>>> I have no clue whatsoever what ntext fields are but you could try a
>>> combination of the following stuff:
>>>
>>> You can try executing this Transact-SQL piece on a query to the server:
>>>
>>> SET TEXTSIZE 64512
>>>
>>> This will change the amount of text returned by a SELECT into a ntext
>>> or nvarchar field.
>>>
>>> If you the upper limit of the size of your text, you can try selecting
>>> it as a substring such as:
>>>
>>> SELECT SUBSTRING(myfield, 1, 4096) AS myfield FROM mytable
>>>
>>> Now, I never faced such issues but then again, I seldon do windows and
>>> the last time I've dealt with MS SQL Server was in 1999...
>>>
>>> Andre
>>
>> _______________________________________________
>> 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