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

Ben Rubinstein benr_mc at
Wed Jan 12 08:41:13 EST 2011

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?



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:
> 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

More information about the Use-livecode mailing list