PowerDesigner数据类型对照表

更新时间:2023-07-13 00:15:11 阅读: 评论:0

PowerDesigner数据类型对照表The following numeric data types are available:
Standard data type DBMS-specific physical
data type格林童话
Content Length
Integer int / INTEGER32-bit integer—Short Integer smallint / SMALLINT16-bit integer—Long Integer int / INTEGER32-bit integer—Byte tinyint / SMALLINT256 values—Number numeric / NUMBER Numbers with a fixed decimal point Fixed Decimal decimal / NUMBER Numbers with a fixed decimal point Fixed Float float / FLOAT32-bit floating point numbers Fixed Short Float real / FLOAT
Less than 32-bit point decimal
number
9月16—Long Float
double precision / BINARY
DOUBLE
忽略造句64-bit floating point numbers—Money money / NUMBER Numbers with a fixed decimal point Fixed
Serial numeric / NUMBER Automatically incremented
numbers
Fixed
Boolean bit / SMALLINT Two opposing values (true/fal;
yes/no; 1/0)
Character data types
The following character data types are available:
Standard data type DBMS-specific physical data五庄观
type
Content Length
Characters char / CHAR Character strings Fixed Variable
Characters
varchar / VARCHAR2Character strings Maximum Long Characters varchar / CLOB Character strings Maximum Long Var
莲子百合银耳汤Characters
团队群名text / CLOB Character strings Maximum Text text / CLOB Character strings Maximum Multibyte nchar / NCHAR
Multibyte character
strings
Fixed Variable
假面君主
Multibyte nvarchar / NVARCHAR2
Multibyte character
strings
Maximum
Time data types
The following time data types are available:
Standard data
type DBMS-specific physical data
type
Content Length
Date date / DATE Day, month, year—Time time / DATE
党委理论中心组
Hour, minute, and
cond
—Date & Time datetime / DATE Date and time—Timestamp timestamp / TIMESTAMP System date and time—
Other data types
The following other data types are available:
Standard data type
DBMS-specific
physical data type
Content Length
Binary binary / RAW Binary strings Maximum Long Binary image / BLOB Binary strings Maximum Bitmap image / BLOB Images in bitmap format (BMP)Maximum Image image / BLOB Images Maxim
um OLE image / BLOB OLE links Maximum Other—Ur-defined data type—
Undefined undefined Undefined. Replaced by the default
data type at generation.

本文发布于:2023-07-13 00:15:11,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/89/1079113.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:数据类型   莲子   群名   理论   对照表
相关文章
留言与评论(共有 0 条评论)
   
验证码:
推荐文章
排行榜
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图