1 Reply Latest reply on Feb 4, 2014 11:29 AM by Steven Hawkins

    Teiid JDBC driver for I18n support

    kchen007 Apprentice

      When we use Teiid JDBC to update a string column with Chinese characters, it writes ??2 to the database, the code looks like this:

         

      TeiidJdbc-1.JPG

      the output of the show plan looks ok:

      TeiidJdbc-2.JPG

       

      If I switch to use prepared statement, it will insert correct value, the code looks like this.

      TeiidJdbc-3.JPG

       

      Can you conform that it is a bug in the Teiid JDBC driver code?

       

      thanks

      Kevin

        • 1. Re: Teiid JDBC driver for I18n support
          Steven Hawkins Master

          > Can you conform that it is a bug in the Teiid JDBC driver code?


          I'm not sure that this is what you're seeing based upon the above. In the show plan you can see on the server side what looks like the appropriate Chinese characters.  I'm assuming that your target source is SQL Server correct?  When you use a prepared statement, then a prepared statement will also be used at source.  More than likely the issue is with the translator/sql server driver handling of a non-prepared string literal with multi-byte characters


          Steve