Tag Archives: MySql
Finding international characters with MySQL
I recently had to find the rows in a database that contained any multibyte characters. My first thought was to leverage the difference between length() and char_length(). The query would be similiar to this: Select pKey, dataCol From myTable Where … Continue reading
MySQL Concat() and Mixed Types
While in the process of upgrading our connector/J to version 5.1 we started seeing the following error: ComplexByteArrayException: ByteArray objects cannot be converted to strings. After doing a little homework we found that the root cause was in the way … Continue reading