Edit

SQL to C: Character

  • Article

The identifiers for the character ODBC SQL data types are the following:

  • SQL_CHAR
  • SQL_VARCHAR
  • SQL_LONGVARCHAR
  • SQL_WCHAR
  • SQL_WVARCHAR
  • SQL_WLONGVARCHAR

The following table shows the ODBC C data types to which character SQL data may be converted. For an explanation of the columns and terms in the table, see Converting Data from SQL to C Data Types.

C type identifier Test TargetValuePtr StrLen_or_IndPtr SQLSTATE
SQL_C_CHAR Byte length of data < BufferLength

Byte length of data >= BufferLength		 Data

Truncated data		 Length of data in bytes

Length of data in bytes		 n/a

01004
SQL_C_WCHAR Character length of data < BufferLength

Character length of data >= BufferLength		 Data

Truncated data		 Length of data in characters

Length of data in characters		 n/a

01004
SQL_C_STINYINT SQL_C_UTINYINT SQL_C_TINYINT SQL_C_SBIGINT SQL_C_UBIGINT SQL_C_SSHORT SQL_C_USHORT SQL_C_SHORT SQL_C_SLONG SQL_C_ULONG SQL_C_LONG SQL_C_NUMERIC Data converted without truncation[b]

Data converted with truncation of fractional digits[a]

Conversion of data would result in loss of whole (as opposed to fractional) digits[a]

Data is not a numeric-literal[b]		 Data

Truncated data

Undefined

Undefined		 Number of bytes of the C data type

Number of bytes of the C data type

Undefined

Undefined		 n/a

01S07

22003

22018
SQL_C_FLOAT SQL_C_DOUBLE Data is within the range of the data type to which the number is being converted[a]

Data is outside the range of the data type to which the number is being converted[a]

Data is not a numeric-literal[b]		 Data

Undefined

Undefined		 Size of the C data type

Undefined

Undefined		 n/a

22003

22018
SQL_C_BIT Data is 0 or 1

Data is greater than 0, less than 2, and not equal to 1

Data is less than 0 or greater than or equal to 2

Data is not a numeric-literal		 Data

Truncated data

Undefined

Undefined		 1[b]

1[b]

Undefined

Undefined		 n/a

01S07

22003

22018
SQL_C_BINARY Byte length of data <= BufferLength

Byte length of data > BufferLength		 Data

Truncated data		 Length of data in bytes

Length of data		 n/a

01004
SQL_C_TYPE_DATE Data value is a valid date-value[a]

Data value is a valid timestamp-value; time portion is zero[a]

Data value is a valid timestamp-value; time portion is nonzero[a],[c]

Data value is not a valid date-value or timestamp-value[a]		 Data

Data

Truncated data

Undefined		 6[b]

6[b]

6[b]

Undefined		 n/a

n/a

01S07

22018
SQL_C_TYPE_TIME Data value is a valid time-value and the fractional seconds value is 0[a]

Data value is a valid timestamp-value or a valid time-value; fractional seconds portion is zero[a],[d]

Data value is a valid timestamp-value; fractional seconds portion is nonzero[a],[d],[e]

Data value is not a valid time-value or timestamp-value[a]		 Data

Data

Truncated data

Undefined		 6[b]

6[b]

6[b]

Undefined		 n/a

n/a

01S07

22018
SQL_C_TYPE_TIMESTAMP Data value is a valid timestamp-value or a valid time-value; fractional seconds portion not truncated[a]

Data value is a valid timestamp-value or a valid time-value; fractional seconds portion truncated[a]

Data value is a valid date-value[a]

Data value is a valid time-value[a]

Data value is not a valid date-value, time-value, or timestamp-value[a]		 Data

Truncated data

Data[f]

Data[g]

Undefined		 16[b]

16[b]

16[b]

16[b]

Undefined		 n/a

01S07

n/a

n/a

22018
All C interval types Data value is a valid interval value; no truncation

Data value is a valid interval value; truncation of one or more trailing fields

Data is valid interval; leading field significant precision is lost

The data value is not a valid interval value		 Data

Truncated data

Undefined

Undefined		 Length of data in bytes

Length of data in bytes

Undefined

Undefined		 n/a

01S07

22015

22018

[a] The value of BufferLength is ignored for this conversion. The driver assumes that the size of *TargetValuePtr is the size of the C data type.

[b] This is the size of the corresponding C data type.

[c] The time portion of the timestamp-value is truncated.

[d] The date portion of the timestamp-value is ignored.

[e] The fractional seconds portion of the timestamp is truncated.

[f] The time fields of the timestamp structure are set to zero.

[g] The date fields of the timestamp structure are set to the current date.

Extra spaces

Leading and trailing spaces are ignored when SQL character data is converted to any of the following types:

  • date
  • numeric
  • time
  • timestamp
  • interval C data