C to SQL: GUID
The identifier for the GUID ODBC C data type is:
SQL_C_GUID
The following table shows the ODBC SQL data types to which GUID C data may be converted. For an explanation of the columns and terms in the table, see Converting Data from C to SQL Data Types.
| SQL type identifier | Test | SQLSTATE |
|---|---|---|
| SQL_CHAR | Column byte length >= 36 | n/a |
| SQL_VARCHAR | Column byte length < 36 | 22001 |
| SQL_LONGVARCHAR | Data value is not a valid GUID | 22018 |
| SQL_WCHAR | Column character length >= 36 | n/a |
| SQL_WVARCHAR | Column character length < 36 | 22001 |
| SQL_WLONGVARCHAR | Data value is not a valid GUID | 22018 |
| SQL_GUID | None[a] | n/a |
[a] All hexidecimal values are valid as a GUID.
The driver ignores the length/indicator value when converting data from the GUID C data type and assumes that the size of the data buffer is the size of the GUID C data type. The length/indicator value is passed in the StrLen_or_Ind argument in SQLPutData and in the buffer specified with the StrLen_or_IndPtr argument in SQLBindParameter. The data buffer is specified with the DataPtr argument in SQLPutData and the ParameterValuePtr argument in SQLBindParameter.