MySQL Text Field as Null

  1. 5 years ago

    TheMexican

    11 Jul 2018 User since 2016

    I believe there is a bug when reading a text field in a Mysql or MariaDB database field.
    To recreate the bug do the following:
    Create a Mysql table with a text type field
    Create a new Database in Creo with a new query and try to read the field, it comes as null

    Let me know if you need more details.
    Maybe it has to do with the Encoding used in the MySQL table.

  2. marco

    11 Jul 2018 Administrator User since 2016

    @TheMexican which encoding is used in that MySQL table?

  3. marco

    11 Jul 2018 Administrator User since 2016

    @TheMexican can you send me a sample project that can reproduce the issue? (even privately)

  4. TheMexican

    11 Jul 2018 User since 2016

    Not sure how to send privately.
    here is the SQL code to recreate the table.

    CREATE TABLE `patients` (
    	`mrn` VARCHAR(50) NOT NULL,
    	`notes` TEXT NULL,
    	PRIMARY KEY (`mrn`)
    )
    COLLATE='latin1_swedish_ci'
    ENGINE=InnoDB
    ;
    

    Let me know if I need to send project privately, but let me know how to send.

  5. marco

    11 Jul 2018 Administrator User since 2016

    Hi @TheMexican issue has been fixed and a new version will be released soon.
    TEXT and BLOB fields return the same type with mySQL so an extra check was required.

or Sign Up to reply!