---
title: "OceanBase Connector/ODBC 数据类型 - ODBC 驱动程序  V2.0.9 | OceanBase 文档中心"
description: OceanBase Connector/ODBC 数据类型 下表展示了 OceanBase Connector/ODBC 如何将服务器端数据类型映射到默认的 SQL 和 C 数据类型的映射关系。 服务器端数据类型 SQL 数据类型 C 数据类型 bigint unsigned SQL_BIGINT SQL_C_UBI…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*0V2BT7xsMSQAAAAAAAAAAAAADiGDAQ/original) ODBC 驱动程序 V 2.0.9

# OceanBase Connector/ODBC 数据类型

更新时间：2026-07-02 12:05:43

[编辑](https://github.com/oceanbase/connector-odbc-doc/edit/V2.0.9/zh-CN/400.reference-information/200.odbc-data-type.md)  

下表展示了 OceanBase Connector/ODBC 如何将服务器端数据类型映射到默认的 SQL 和 C 数据类型的映射关系。

| **服务器端数据类型** | **SQL 数据类型** | **C 数据类型** |
| --- | --- | --- |
| **bigint unsigned** | SQL_BIGINT | SQL_C_UBIGINT |
| **bigint** | SQL_BIGINT | SQL_C_SBIGINT |
| **bit** | SQL_BIT | SQL_C_BIT |
| **bit** | SQL_CHAR | SQL_C_CHAR |
| **blob** | SQL_LONGVARBINARY | SQL_C_BINARY |
| **bool** | SQL_CHAR | SQL_C_CHAR |
| **char** | SQL_CHAR | SQL_C_CHAR |
| **date** | SQL_DATE | SQL_C_DATE |
| **datetime** | SQL_TIMESTAMP | SQL_C_TIMESTAMP |
| **decimal** | SQL_DECIMAL | SQL_C_CHAR |
| **double precision** | SQL_DOUBLE | SQL_C_DOUBLE |
| **double** | SQL_FLOAT | SQL_C_DOUBLE |
| **enum** | SQL_VARCHAR | SQL_C_CHAR |
| **float** | SQL_REAL | SQL_C_FLOAT |
| **int unsigned** | SQL_INTEGER | SQL_C_ULONG |
| **int** | SQL_INTEGER | SQL_C_SLONG |
| **integer unsigned** | SQL_INTEGER | SQL_C_ULONG |
| **integer** | SQL_INTEGER | SQL_C_SLONG |
| **longblob** | SQL_LONGVARBINARY | SQL_C_BINARY |
| **longtext** | SQL_LONGVARCHAR | SQL_C_CHAR |
| **mediumblob** | SQL_LONGVARBINARY | SQL_C_BINARY |
| **mediumint unsigned** | SQL_INTEGER | SQL_C_ULONG |
| **mediumint** | SQL_INTEGER | SQL_C_SLONG |
| **mediumtext** | SQL_LONGVARCHAR | SQL_C_CHAR |
| **numeric** | SQL_NUMERIC | SQL_C_CHAR |
| **real** | SQL_FLOAT | SQL_C_DOUBLE |
| **set** | SQL_VARCHAR | SQL_C_CHAR |
| **smallint unsigned** | SQL_SMALLINT | SQL_C_USHORT |
| **smallint** | SQL_SMALLINT | SQL_C_SSHORT |
| **text** | SQL_LONGVARCHAR | SQL_C_CHAR |
| **time** | SQL_TIME | SQL_C_TIME |
| **timestamp** | SQL_TIMESTAMP | SQL_C_TIMESTAMP |
| **tinyblob** | SQL_LONGVARBINARY | SQL_C_BINARY |
| **tinyint unsigned** | SQL_TINYINT | SQL_C_UTINYINT |
| **tinyint** | SQL_TINYINT | SQL_C_STINYINT |
| **tinytext** | SQL_LONGVARCHAR | SQL_C_CHAR |
| **varchar** | SQL_VARCHAR | SQL_C_CHAR |
| **year** | SQL_SMALLINT | SQL_C_SHORT |

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线