Thursday, July 18, 2013

SOLVED: Unknown type '246 in column 2 of 3 in binary-encoded result set


Today at our firm was problem like as "Unknown type '246 in column 2 of 3 in binary-encoded result set" when selected table has column as decimal(10, 2) type. This errors cause because we use old version of mysql jdbc driver. Solution for this problem is:
  1. Download new version of driver
  2. Convert double column to char on selection.
    SELECT CAST(your_column AS char(15)) your_column FROM your_table;
    So in this case on java side u can get it as Double again.
That is all u need know to solve this problem :))

1 comment:

  1. Cheap Wildcard SSL - Cheap SSL certificates (including wildcard and multi-domain (SAN) SSL certificates) from Comodo, GeoTrust, Thawte and Symantec (VeriSign)

    ReplyDelete