Home » SQL & PL/SQL » SQL & PL/SQL » LENGHTB , LENGTH , WHAT'S THE DIFFERENCE ????
LENGHTB , LENGTH , WHAT'S THE DIFFERENCE ???? [message #39306] Thu, 04 July 2002 19:12 Go to next message
Koala
Messages: 31
Registered: May 2002
Member
What is the difference between LENGTHB & LENGTH ??
Re: LENGHTB , LENGTH , WHAT'S THE DIFFERENCE ???? [message #39308 is a reply to message #39306] Thu, 04 July 2002 22:03 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
LENGTH returns the length of a string in characters.
LENGTHB returns the length of a string in bytes.

For a single-byte database character set, LENGTHB is equivalent to LENGTH.
Previous Topic: LENGTH , LENGTHB , What's the difference ??
Next Topic: how to calculate the storage size of table and index
Goto Forum:
  


Current Time: Fri Mar 29 00:42:19 CDT 2024