Home » SQL & PL/SQL » SQL & PL/SQL » LENGTH , LENGTHB , What's the difference ??
LENGTH , LENGTHB , What's the difference ?? [message #20986] Thu, 04 July 2002 19:21 Go to next message
Koala
Messages: 31
Registered: May 2002
Member
What is the difference between LENGTH & LENGTHB ??

Report message to a moderator

Re: LENGTH , LENGTHB , What's the difference ?? [message #20991 is a reply to message #20986] Thu, 04 July 2002 22:02 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.

Report message to a moderator

Previous Topic: how can i terminate a transaction but can't kill session
Next Topic: LENGHTB , LENGTH , WHAT'S THE DIFFERENCE ????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:53:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.