Unidata BCI & nvarchar(max) - help. Info missing from ODBC.H

Hi Elaine,

I've checked and these are the SQL datatypes we currenlty support.

145: * Define all SQL data types
146: * and those that we support
147:
148: EQU SQL.CHAR                            TO                1
149: EQU SQL.NUMERIC                         TO                2
150: EQU SQL.DECIMAL                         TO                3
151: EQU SQL.INTEGER                         TO                4
152: EQU SQL.SMALLINT                        TO                5
153: EQU SQL.FLOAT                           TO                6
154: EQU SQL.REAL                            TO                7
155: EQU SQL.DOUBLE                          TO                8
156: EQU SQL.DATE                            TO                9
157: EQU SQL.TIME                            TO               10
158: EQU SQL.TIMESTAMP                       TO               11
159: EQU SQL.VARCHAR                         TO               12
160: EQU SQL.LONGVARCHAR                     TO               -1
161: EQU SQL.BINARY                          TO               -2
162: EQU SQL.VARBINARY                       TO               -3
163: EQU SQL.LONGVARBINARY                   TO               -4
164: EQU SQL.BIGINT                          TO               -5
165: EQU SQL.TINYINT                         TO               -6
166: EQU SQL.BIT                             TO               -7
167: EQU NUM.SQL.TYPES                       TO               19

The folloiwng are the conversions types (SQL.B.BASIC) we currently support

199: * Valid BASIC data types
200:
201: EQU SQL.B.BASIC                         TO              100
202: EQU SQL.B.INTDATE                       TO              101
203: EQU SQL.B.NUMBER                        TO              102
204: EQU SQL.B.INTTIME                       TO              103
205: EQU SQL.B.CHAR                          TO                1
206: EQU SQL.B.DEFAULT                       TO               99
207:

Currently we do not have any types that support Unicode data types. If you need Unicode support added then this is something we need to look into via an enhancement request. Would it be possible for you to raise a support call with us or via your support provider, so that we can discuss and ensure that we fully understand your requirements.

Thanks,

Thank you Jonathan. I'll log a call for the request. The 8.2.4 documentation references both those types. Apparently I do not have it figured out after all. 

Hi Elaine,

I have done some more digging and I can see the source of your confussion between what has been added to documentation and what the include definition states. I will hopefully have an answer for you shortly.

Thanks,

Jonathan

Hi Elaine,

I have also found definitions missing in the include record for the data types, for example SQL.B.BINARY is missing. I will keep you posted.

Thanks,

Thank you Jonathan, for both your help and the updates to odbc.h!

For others who are interested it looks like the following values are missing from the ODBC.H INCLUDE record in UniData.

Under the section

* Define all SQL data types
* and those that we support

EQU SQL.WCHAR                           TO               -8
EQU SQL.WVARCHAR                        TO               -9
EQU SQL.WLONGVARCHAR                    TO               -10

Under the section

* Valid BASIC data types

 EQU SQL.B.BINARY                        TO               -2

You also need to change the line

 EQU NUM.SQL.TYPES            TO        19  to

 EQU NUM.SQL.TYPES            TO        22