2 Replies Latest reply on May 16, 2016 8:13 AM by Marco Ardito

    Overriding collate in a query, possible?

    Marco Ardito Master

      Many of my "source" mysql table have case insensitive collation by default but, where needed, I can request collation override using a syntax like


      SELECT* FROM ag WHERE ag.name LIKE '%è%'  COLLATE utf8_bin


      Now I need to be able to do the same accessing that data from Teiid vdb model....


      is it possible, and how?