Find ntext column type data length in sql 2000

Question

I have data in an NTEXT type column. I wanted to know the length of the data using a query in sql 2000

----- Updates -----

HI, I used to use datalength. But strange is his return of the wrong values. Is there any other problem I have to check.

Answer 1

Do you want DATALENGTH() ;

 SELECT DATALENGTH(ntextcol) FROM T 

Answer 2

You can use DATALENGTH .

For the datatype ntext type, the ntext size in bytes is two times larger than the entered characters

This can be confusing.

Answer 3

You can use DATALENGTH to get NTEXT length

Answer 4

  Create table TestTable
 (
     Id int identity, NtextCol NTEXT
 )
 GO
 insert into TestTable
 Select 'yogesh'
 GO
 insert into TestTable
 Select 'bhadauriya'

 Select Datalength (NtextCol) - get lenght of the data
 From testtable

 Go
 Drop table TestTable

Answer 5

You can also use LEN ( string_expression ) , where string_expression can be a string expression that needs to be evaluated. string_expression can be a constant, a variable, or a column of either character or binary data.

Answer 6

ssilas777 mentions "Storage size in bytes, two times the entered characters"

Given this, datalength([nTextColumn]) / 2 as nTextColumn_length should return the specific response specified in the original message.