Informix

 View Only

Informix V15 and better GLS: What about char length semantics?

  • 1.  Informix V15 and better GLS: What about char length semantics?

    Posted Fri March 29, 2024 04:05 AM

    Hello,

    GLS improvements have been mentioned during yesterday's presentation about version 15.
    Several years ago, we suggested to have proper Character Length Semantics (CLS) support, like in other DB engines.
    Will there be an improvement in this area?
    Without CLS, it makes character manipulation more complex when using UTF-8 character encoding.
    In our case, even if we support both BLS and CLS in Genero BDL, one must use the same length semantics as the target database.
    When using other DB engines like Oracle or PostgreSQL, our customers can use CLS and string manipulation is easy.
    When using Informix, they are forced to use BLS and string manipulation is difficult (LET substr = origstr[5,7])

    Side note: We would have been pleased to beta-test v15 with our large QA test suite.
    Our solution is using Informix CSDK ESQL/C.
    If IBM/HCL people are interested by this offer, please contact me.

    BR,
    Seb



    ------------------------------
    Sebastien FLAESCH
    ------------------------------