Issue 246: varchar can't execute
Status:  NoFix
Owner: ----
Closed:  Sep 2012
Reported by dunshir...@gmail.com, Mar 11, 2012
I'm using altibase and python3,but can not work when the row is varchar;

ex:
iSQL> desc area_info;
[ ATTRIBUTE ]                                                         
------------------------------------------------------------------------------
NAME                                     TYPE                        IS NULL 
------------------------------------------------------------------------------
AREA_ID                                  INTEGER         FIXED       NOT NULL
CITY_CODE                                VARCHAR(10)     FIXED       NOT NULL
AREA_CODE                                VARCHAR(10)     FIXED       NOT NULL
AREA_NAME                                VARCHAR(50)     FIXED       NOT NULL
PARENT_PROV                              VARCHAR(10)     FIXED       NOT NULL
PARENT_NATION                            VARCHAR(10)     FIXED       NOT NULL


In [48]: s.execute("select * From area_info where area_code = ?",'0998')
---------------------------------------------------------------------------
Error                                     Traceback (most recent call last)
D:\Program Files\Console2\<ipython-input-48-142f0158a9a9> in <module>()
----> 1 s.execute("select * From area_info where area_code = ?",'0998')

Error: ('07006', '[07006] Restricted data type attribute violation (331803) (SQLBindParameter)')


Jun 23, 2012
Project Member #1 mkleehammer
I don't have an Altibase database.  Can you generate an ODBC trace?
Status: Hold
Sep 29, 2012
Project Member #2 mkleehammer
Closing due to no response.

Status: NoFix