SQL Server Forums - how to get the length of text datatype column?

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to get the length of text datatype column?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

gsrinivas.
Yak Posting Veteran

53 Posts

Posted - 05/08/2010 : 10:12:22

Dear sql team,
how to find the length of text data type column?

my column contains some sqltext(ie sql view text)
i want to find that length of text for each row.
normal length functions are not working.

please tell me.

-thanks
srinivas.

visakh16
Very Important crosS Applying yaK Herder

India
47099 Posts

Posted - 05/08/2010 : 10:35:26

use DATALENGTH function.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

gsrinivas.
Yak Posting Veteran

53 Posts

Posted - 05/11/2010 : 09:39:43

thanks visakh16,
and I will try.
does it work in oracle ?
in oracle, the data type is CLOB(Character Long Object)while in SQL Server is TEXT data type.

plz specify a function for oracle also

Thanks,
Srinivas.

1dmf
Starting Member

5 Posts

Posted - 05/11/2010 : 11:01:49

Does this help?

http://www.google.co.uk/#hl=en&source=hp&q=oracle+DATALENGTH+function&meta=&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=71f60c6bcc41f992

gsrinivas.
Yak Posting Veteran

53 Posts

Posted - 05/14/2010 : 04:36:10

I am unable to find the function for length of CLOB in oracle.

can any one help plz..

-thanks
srini

madhivanan
Premature Yak Congratulator

India
22461 Posts

Posted - 05/14/2010 : 05:34:13