When we use Teiid JDBC to update a string column with Chinese characters, it writes ??2 to the database, the code looks like this:
the output of the show plan looks ok:
If I switch to use prepared statement, it will insert correct value, the code looks like this.
Can you conform that it is a bug in the Teiid JDBC driver code?
thanks
Kevin
> 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