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

Andre Garzia andre at andregarzia.com
Wed Jan 12 07:55:36 CST 2011


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
>



-- 
http://www.andregarzia.com All We Do Is Code.



More information about the use-livecode mailing list