App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Oracle to MySQL Migration - MySQL is returning column name in small case while oracle was returning in Upper Case

  • 1.  Oracle to MySQL Migration - MySQL is returning column name in small case while oracle was returning in Upper Case

    Posted Sun October 08, 2023 07:30 AM

    Hi All,

    We recently migrated from Oracle to MySQL. On mySQL column name returned are in small case, while it was in upper case in Orcale. It is forcing us to change the code, which is huge task. Is there any parameter we can set at ODBC.ini level, which will fix this?



    ------------------------------
    satyam maurya
    ------------------------------


  • 2.  RE: Oracle to MySQL Migration - MySQL is returning column name in small case while oracle was returning in Upper Case

    Posted Mon October 09, 2023 08:25 AM

    In MYSQL did you create the column with lower or upper case in the column name ?



    ------------------------------
    Francois Brandelik
    ------------------------------

    Original Message


Related Content