Oracle 10g ×ֶγ¤¶ÈµÄÎÊÌâ!

żÓõÄÊÇOracle 10.1 G,Óöµ½ÒÔÏÂÎÊÌâ,µ÷ÊÔÁ˺ܾÃ,¾ÍÊǵ÷²»³É¹¦,ÇëÇóÍøÓÑ°ïæ!

SQL> CREATE TABLE person (
  2  pid  VARCHAR2(18),
  3  name  VARCHAR2(200),
  4  age  NUMBER(3),
  5  birthday DATE,
  6  sex  VARCHAR2(2) DEFAULT 'ÄÐ'
  7  );
sex  VARCHAR2(2) DEFAULT 'ÄÐ'
                          *
µÚ 6 ÐгöÏÖ´íÎó:
ORA-01401: ²åÈëµÄÖµ¶ÔÓÚÁйý´ó

---

SQL> CREATE TABLE person (
  2      pid  VARCHAR2(18),
  3    name  VARCHAR2(200),
  4      age  NUMBER(3),
  5      birthday DATE,
  6      sex  VARCHAR2(2) DEFAULT 'ÄÐ'
  7      );

±íÒÑ´´½¨¡£
û´í°¡£¬ÊDz»ÊÇÄã¶à¼ÓÁË¿Õ¸ñŶ£¬³ÉÁËÕâÑù' ÄÐ'

---

The VARCHAR2 and CHAR types support two methods of specifying lengths:
• In bytes: VARCHAR2(10 byte). This will support up to 10 bytes of data, which could be as few as two characters in a multibyte character set.

• In characters: VARCHAR2(10 char). This will support to up 10 characters of data, which could be as much as 40 bytes of information.

---

ORA-01401: inserted value too