Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect SQL_DESC_TYPE_NAME for 'blob sub_type text' data type [ODBC132] #129

Closed
firebird-automations opened this issue Oct 2, 2011 · 11 comments

Comments

@firebird-automations
Copy link

Submitted by: faridz (faridz)

Attachments:
fb_blob_data_type.jpg
screenshot2.jpg
screen3.jpg

Firebird/Interbase(r) driver 2.00.00.151 64-bit

Driver returns 'LONG VARCHAR' for SQL_DESC_TYPE_NAME for 'blob sub_type text' column. Should return 'blob sub_type text' (same as from ::SQLGetTypeInfo for the data type)

Example,

create table test_data_type (
col_sql_wchar char(20) character set unicode_fss,
col_sql_wvarchar varchar(20) character set unicode_fss,
col_sql_wlongvarchar blob sub_type text character set unicode_fss,
col_sql_longvarchar blob sub_type text,
col_sql_longvarbinary blob
)
// type_name
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_TYPE_NAME,
pRow->type_name,
sizeof(pRow->type_name),
&nLen,
NULL);

Commits: 988b41d b2fc94b

@firebird-automations
Copy link
Author

Modified by: faridz (faridz)

Attachment: fb_blob_data_type.jpg [ 12015 ]

@firebird-automations
Copy link
Author

Commented by: faridz (faridz)

[removed comment]

1 similar comment
@firebird-automations
Copy link
Author

Commented by: faridz (faridz)

[removed comment]

@firebird-automations
Copy link
Author

Modified by: faridz (faridz)

Attachment: screenshot2.jpg [ 12019 ]

@firebird-automations
Copy link
Author

Commented by: faridz (faridz)

Update example with additional data types

@firebird-automations
Copy link
Author

Modified by: faridz (faridz)

description: Firebird/Interbase(r) driver 2.00.00.151 64-bit

Driver returns 'LONG VARCHAR' for SQL_DESC_TYPE_NAME for 'blob sub_type text' column. Should return 'blob sub_type text'

Example,

create table test_char (
col1 int not null,
OBJECT_SCRIPT blob sub_type text
);

    // type\_name
    rc = SQLColAttribute\(hstmt,
                         nCol,
                         SQL\_DESC\_TYPE\_NAME,
                         pRow\-\>type\_name,
                         sizeof\(pRow\-\>type\_name\),
                         &nLen,
                         NULL\);

=>

Firebird/Interbase(r) driver 2.00.00.151 64-bit

Driver returns 'LONG VARCHAR' for SQL_DESC_TYPE_NAME for 'blob sub_type text' column. Should return 'blob sub_type text' (same as from ::SQLGetTypeInfo for the data type)

Example,

create table test_data_type (
col_sql_wchar CHAR(20) CHARACTER SET UNICODE_FSS,
col_sql_wvarchar VARCHAR(20) CHARACTER SET UNICODE_FSS,
col_sql_wlongvarchar BLOB SUB_TYPE TEXT CHARACTER SET UNICODE_FSS,
col_sql_longvarchar BLOB SUB_TYPE TEXT,
col_sql_longvarbinary blob
)
// type_name
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_TYPE_NAME,
pRow->type_name,
sizeof(pRow->type_name),
&nLen,
NULL);

@firebird-automations
Copy link
Author

Modified by: faridz (faridz)

description: Firebird/Interbase(r) driver 2.00.00.151 64-bit

Driver returns 'LONG VARCHAR' for SQL_DESC_TYPE_NAME for 'blob sub_type text' column. Should return 'blob sub_type text' (same as from ::SQLGetTypeInfo for the data type)

Example,

create table test_data_type (
col_sql_wchar CHAR(20) CHARACTER SET UNICODE_FSS,
col_sql_wvarchar VARCHAR(20) CHARACTER SET UNICODE_FSS,
col_sql_wlongvarchar BLOB SUB_TYPE TEXT CHARACTER SET UNICODE_FSS,
col_sql_longvarchar BLOB SUB_TYPE TEXT,
col_sql_longvarbinary blob
)
// type_name
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_TYPE_NAME,
pRow->type_name,
sizeof(pRow->type_name),
&nLen,
NULL);

=>

Firebird/Interbase(r) driver 2.00.00.151 64-bit

Driver returns 'LONG VARCHAR' for SQL_DESC_TYPE_NAME for 'blob sub_type text' column. Should return 'blob sub_type text' (same as from ::SQLGetTypeInfo for the data type)

Example,

create table test_data_type (
col_sql_wchar char(20) character set unicode_fss,
col_sql_wvarchar varchar(20) character set unicode_fss,
col_sql_wlongvarchar blob sub_type text character set unicode_fss,
col_sql_longvarchar blob sub_type text,
col_sql_longvarbinary blob
)
// type_name
rc = SQLColAttribute(hstmt,
nCol,
SQL_DESC_TYPE_NAME,
pRow->type_name,
sizeof(pRow->type_name),
&nLen,
NULL);

@firebird-automations
Copy link
Author

Commented by: faridz (faridz)

sql data type number for column 3 from SQL_DESC_CONCISE_TYPE / SQL_DESC_TYPE appears wrong (should say SQL_WLONGVARCHAR instead of SQL_LONGVARCHAR).

@firebird-automations
Copy link
Author

Modified by: faridz (faridz)

Attachment: screen3.jpg [ 12020 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.1 [ 10430 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants