String length: Difference between revisions

Content deleted Content added
m adding gap
Line 1,273:
 
=={{header|PL/SQL}}==
LENGTH calculates length using characters as defined by the input character set.
LENGTHB uses bytes instead of characters.
LENGTHC uses Unicode complete characters.
LENGTH2 uses UCS2 code points.
LENGTH4 uses UCS4 code points.
===Byte Length===
{{needs-review|PL/SQL}}
<lang plsql>DECLARE
string VARCHAR2( 50 ) := 'Hello, world!';
stringlength NUMBER;
BEGIN
stringlength := LENGTHB( string );
END;</lang>
 
===Character Length===
{{needs-review|PL/SQL}}
<lang plsql>DECLARE
string VARCHAR2( 50 ) := 'Hello, world!';
stringlength NUMBER;
unicodelength NUMBER;
ucs2length NUMBER;
ucs4length NUMBER;
BEGIN
stringlength := lengthLENGTH( string );
unicodelength := LENGTHC(string);
ucs2length := LENGTH2(string);
ucs4length := LENGTH4(string);
END;</lang>