Title |
[ORACLE] テーブル生成構文によってColumn Lengthの長さが変わる | Product |
Plug-In |
---|---|---|---|
Phenomenon |
テーブル生成構文によってColumn Lengthの長さが変わる。
(DBA_TAB_COLUMNSテーブルのdata_lengthから確認できる) |
||
Cause |
. |
||
Solution |
VARCHAR2(15 CHAR) :
character set => KO16KSC5601/KO16MSWIN949 Column Length => 15*2=30 character set => UTF8/AL32UTF8 Column Length => 15*4=60 VARCHAR2(15 BYTE) : character set => KO16KSC5601/KO16MSWIN949 Column Length => 15 character set => UTF8/AL32UTF8 Column Length => 15 VARCHAR2(15) : character set => KO16KSC5601/KO16MSWIN949 Column Length => 15 character set => UTF8/AL32UTF8 Column Length => 15 |