#28 ResultSetMetaData BLOB/TEXT issue

open
nobody
None
5
2001-11-23
2001-11-23
No

ResultSetMetaData.getColumnTypeName(int)[419] returns
on BLOB fields "TEXT" if the column is binary marked
and "BLOB" if not.
This seems to be a bug, since it should be the other
way round.
Correct me please if I am wrong.

Discussion

  • Mark Matthews

    Mark Matthews - 2002-01-19

    Logged In: YES
    user_id=116907

    Need sample table to reproduce.

     
  • Nobody/Anonymous

    Logged In: NO

    Here is a table that you can use to produce the error.
    +----------------------+----------------+-------+--------+---------+---------+
    | Field | Type | Null | Key | Default | Extra |
    +----------------------+----------------+-------+-------+---------+----------+
    | MESSAGE_ID | varchar(50) | | PRI | | |
    | FROM_ | blob | YES| | NULL | |
    +---------------------+-----------------+------+-------+----------+----------

    CREATE TABLE STATEMENT
    mysql> create table testDB (MESSAGE_ID VARCHAR(50)
    NOT NULL,FROM_ BLOB, PRIMARY
    KEY(MESSAGE_ID));

    INSERT DATA INTO TABLE STATMENTS
    mysql> INSERT INTO testDB VALUES ('10001','SOMETHING
    HERE');
    Query OK, 1 row affected (0.00 sec)

    mysql> INSERT INTO testDB VALUES ('10002','SOMETHING
    THERE');
    Query OK, 1 row affected (0.00 sec)

    A call to getColumnTypeName(int) returns Text and a call to
    getColumnType(int) returns -4.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks