{"id":295,"date":"2012-03-15T11:24:24","date_gmt":"2012-03-15T11:24:24","guid":{"rendered":"http:\/\/ahsiu.com\/?p=295"},"modified":"2012-03-15T11:24:24","modified_gmt":"2012-03-15T11:24:24","slug":"powerdesigner%e4%b8%ad%e7%9a%84%e6%95%b0%e6%8d%ae%e7%b1%bb%e5%9e%8b%e5%af%b9%e7%85%a7%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/blog.xiunian.wang\/?p=295","title":{"rendered":"PowerDesigner\u4e2d\u7684\u6570\u636e\u7c7b\u578b\u5bf9\u7167\u8868"},"content":{"rendered":"

The following numeric data types are available:<\/strong><\/p>\n

<\/strong>Standard data type<\/p>\n

DBMS-specific physical data type
\nContent
\nLength<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Integer<\/td>\nint \/ INTEGER<\/td>\n32-bit integer<\/td>\n\u2014<\/td>\n<\/tr>\n
Short Integer<\/td>\nsmallint \/ SMALLINT<\/td>\n16-bit integer<\/td>\n\u2014<\/td>\n<\/tr>\n
Long Integer<\/td>\nint \/ INTEGER<\/td>\n32-bit integer<\/td>\n\u2014<\/td>\n<\/tr>\n
Byte<\/td>\ntinyint \/ SMALLINT<\/td>\n256 values<\/td>\n\u2014<\/td>\n<\/tr>\n
Number<\/td>\nnumeric \/ NUMBER<\/td>\nNumbers with a fixed decimal point<\/td>\nFixed<\/td>\n<\/tr>\n
Decimal<\/td>\ndecimal \/ NUMBER<\/td>\nNumbers with a fixed decimal point<\/td>\nFixed<\/td>\n<\/tr>\n
Float<\/td>\nfloat \/ FLOAT<\/td>\n32-bit floating point numbers<\/td>\nFixed<\/td>\n<\/tr>\n
Short Float<\/td>\nreal \/ FLOAT<\/td>\nLess than 32-bit point decimal number<\/td>\n\u2014<\/td>\n<\/tr>\n
Long Float<\/td>\ndouble precision \/ BINARY DOUBLE<\/td>\n64-bit floating point numbers<\/td>\n\u2014<\/td>\n<\/tr>\n
Money<\/td>\nmoney \/ NUMBER<\/td>\nNumbers with a fixed decimal point<\/td>\nFixed<\/td>\n<\/tr>\n
Serial<\/td>\nnumeric \/ NUMBER<\/td>\nAutomatically incremented numbers<\/td>\nFixed<\/td>\n<\/tr>\n
Boolean<\/td>\nbit \/ SMALLINT<\/td>\nTwo opposing values (true\/false; yes\/no; 1\/0)<\/td>\n\u2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Character data types :<\/strong><\/p>\n

 <\/p>\n

Standard data type
\nDBMS-specific physical data type
\nContent
\nLength<\/p>\n\n\n\n\n\n\n\n\n\n
Characters<\/td>\nchar \/ CHAR<\/td>\nCharacter strings<\/td>\nFixed<\/td>\n<\/tr>\n
Variable Characters<\/td>\nvarchar \/ VARCHAR2<\/td>\nCharacter strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Long Characters<\/td>\nvarchar \/ CLOB<\/td>\nCharacter strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Long Var Characters<\/td>\ntext \/ CLOB<\/td>\nCharacter strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Text<\/td>\ntext \/ CLOB<\/td>\nCharacter strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Multibyte<\/td>\nnchar \/ NCHAR<\/td>\nMultibyte character strings<\/td>\nFixed<\/td>\n<\/tr>\n
Variable Multibyte<\/td>\nnvarchar \/ NVARCHAR2<\/td>\nMultibyte character strings<\/td>\nMaximum<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Time data types:<\/strong><\/p>\n

 <\/p>\n

Standard data type
\nDBMS-specific physical data type
\nContent
\nLength<\/p>\n\n\n\n\n\n\n
Date<\/td>\ndate \/ DATE<\/td>\nDay, month, year<\/td>\n\u2014<\/td>\n<\/tr>\n
Time<\/td>\ntime \/ DATE<\/td>\nHour, minute, and second<\/td>\n\u2014<\/td>\n<\/tr>\n
Date & Time<\/td>\ndatetime \/ DATE<\/td>\nDate and time<\/td>\n\u2014<\/td>\n<\/tr>\n
Timestamp<\/td>\ntimestamp \/ TIMESTAMP<\/td>\nSystem date and time<\/td>\n\u2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Other data types :<\/strong><\/p>\n

 <\/p>\n

Standard data type
\nDBMS-specific physical data type
\nContent
\nLength<\/p>\n\n\n\n\n\n\n\n\n\n
Binary<\/td>\nbinary \/ RAW<\/td>\nBinary strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Long Binary<\/td>\nimage \/ BLOB<\/td>\nBinary strings<\/td>\nMaximum<\/td>\n<\/tr>\n
Bitmap<\/td>\nimage \/ BLOB<\/td>\nImages in bitmap format (BMP)<\/td>\nMaximum<\/td>\n<\/tr>\n
Image<\/td>\nimage \/ BLOB<\/td>\nImages<\/td>\nMaximum<\/td>\n<\/tr>\n
OLE<\/td>\nimage \/ BLOB<\/td>\nOLE links<\/td>\nMaximum<\/td>\n<\/tr>\n
Other<\/td>\n\u2014<\/td>\nUser-defined data type<\/td>\n\u2014<\/td>\n<\/tr>\n
Undefined<\/td>\nundefined<\/td>\nUndefined. Replaced by the default data type at generation.<\/td>\n\u2014<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

The following numeric data types are available: Standard data type DBMS-specific physical data type Content Length Integer int \/ INTEGER 32-bit integer \u2014 Short Integer smallint \/ SMALLINT 16-bit integer \u2014 Long Integer int \/ INTEGER 32-bit integer \u2014 Byte tinyint \/ SMALLINT 256 values \u2014 Number numeric \/ NUMBER Numbers with a fixed decimal … <\/p>\n

Continue reading “PowerDesigner\u4e2d\u7684\u6570\u636e\u7c7b\u578b\u5bf9\u7167\u8868”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts\/295"}],"collection":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=295"}],"version-history":[{"count":0,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=\/wp\/v2\/posts\/295\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xiunian.wang\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}