Code Listing 1: Is fixed-length really fixed?
SQL> DECLARE

  2     x CHAR(3);
  3  BEGIN
  4     x := 'a';
  5     DBMS_OUTPUT.PUT_LINE(LENGTH(x));
  6     x := 'ã';

  7     DBMS_OUTPUT.PUT_LINE(LENGTH(x));
  8  END;
  9  /
3
2
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy