Bug #29356 Wrong result from CONCAT function if character set SJIS is used
Submitted: 26 Jun 2007 11:18
Reporter: Sveta Smirnova
Status: Verified
Category:Connector/J Severity:S3 (Non-critical)
Version:3.0, 3.1, 5.0 OS:Any
Assigned to: Target Version:
Tags: regression
Triage: D3 (Medium)

[26 Jun 2007 11:18] Sveta Smirnova
Description:
If issue query "select CONCAT(12,'ヶ月')" with program using Connector/J garbage result
is provided.

Bug doesn't exists in version 3.0.11

Workaround: use query "select CONCAT('12','ヶ月')" or "select CONCAT(cast(12 as
char),'ヶ月')" instead of original one.

How to repeat:
See description