Numeric Data Types
Unless otherwise specified, the precision, scale, and number of digits cannot be set to floating-point values in M-compatible mode by default. You are advised to use valid integer values.
MySQL |
GaussDB |
Difference |
---|---|---|
DECIMAL[(M[,D])] [ZEROFILL] |
Supported, with differences. |
- |
NUMERIC[(M[,D])] [ZEROFILL] |
Supported, with differences. |
|
DEC[(M[,D])] [ZEROFILL] |
Supported, with differences. |
|
FIXED[(M[,D])] [ZEROFILL] |
Supported, with differences. |
MySQL |
GaussDB |
Difference |
---|---|---|
FLOAT[(M,D)] [ZEROFILL] |
Supported, with differences. |
The FLOAT data type does not support partitioned tables with the key partitioning policy. |
FLOAT(p) [ZEROFILL] |
Supported, with differences. |
The FLOAT data type does not support partitioned tables with the key partitioning policy. |
DOUBLE[(M,D)] [ZEROFILL] |
Supported, with differences. |
The DOUBLE data type does not support partitioned tables with the key partitioning policy. |
DOUBLE PRECISION[(M,D)] [ZEROFILL] |
Supported, with differences. |
The DOUBLE PRECISION data type does not support partitioned tables with the key partitioning policy. |
REAL[(M,D)] [ZEROFILL] |
Supported, with differences. |
The REAL data type does not support partitioned tables with the key partitioning policy. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot