# openGauss To GaussDB 数据类型转换
| 源数据库数据类型                    | 转换后数据类型                     | 相关的转换配置                                                                                                                   |
|:---|:---|:---|
| SMALLINT                    | SMALLINT                    | -                                                                                                                         |
| INTEGER                     | INTEGER                     | -                                                                                                                         |
| BIGINT                      | BIGINT                      | -                                                                                                                         |
| INTEGER                     | INTEGER                     | -                                                                                                                         |
| REAL                        | REAL                        | -                                                                                                                         |
| DOUBLE PRECISION            | DOUBLE PRECISION            | -                                                                                                                         |
| NUMERIC                     | NUMERIC                     | -                                                                                                                         |
| CHARACTER VARYING           | CHARACTER VARYING           | 字符数据类型转换 ``` 选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。 ```  |
| CHARACTER                   | CHARACTER                   | 字符数据类型转换 ``` 选择配置项的值为“扩展字符数据类型char/varchar长度。”，可与DRS转换后在GaussDB 存储等价。 ``` |
| BIT                         | BIT                         | -                                                                                                                         |
| BIT VARYING                 | BIT VARYING                 | -                                                                                                                         |
| BOOLEAN                     | BOOLEAN                     | -                                                                                                                         |
| BYTEA                       | BYTEA                       | -                                                                                                                         |
| TEXT                        | TEXT                        | -                                                                                                                         |
| TIME WITHOUT TIME ZONE      | TIME WITHOUT TIME ZONE      | -                                                                                                                         |
| TIME WITH TIME ZONE         | TIME WITH TIME ZONE         | -                                                                                                                         |
| TIMESTAMP WITHOUT TIME ZONE | TIMESTAMP WITHOUT TIME ZONE | -                                                                                                                         |
| TIMESTAMP WITH TIME ZONE    | TIMESTAMP WITH TIME ZONE    | -                                                                                                                         |
| INTERVAL                    | INTERVAL                    | -                                                                                                                         |
| CIDR                        | CIDR                        | -                                                                                                                         |
| PATH                        | PATH                        | -                                                                                                                         |
| BOX                         | BOX                         | -                                                                                                                         |
| LSEG                        | LSEG                        | -                                                                                                                         |
| MACADDR                     | MACADDR                     | -                                                                                                                         |
| POINT                       | POINT                       | -                                                                                                                         |
| POLYGON                     | POLYGON                     | -                                                                                                                         |
| INET                        | INET                        | -                                                                                                                         |
| TSQUERY                     | TSQUERY                     | -                                                                    |
| TSVECTOR                    | TSVECTOR                    | -                                                                      |
| UUID                        | UUID                        | -                                                                    |
| JSON                        | JSON                        |  -                                                                                                                  |
| JSONB                       | JSONB                       | -                                                                                                                         |