• unknown's avatar
    Bug#18691: Converting number to UNICODE string returns invalid result. · 5c0c1dcc
    unknown authored
    Conversion from int and real numbers to UCS2 didn't work fine: 
    CONVERT(100, CHAR(50) UNICODE)
    CONVERT(103.9, CHAR(50) UNICODE)
    
    The problem appeared because numbers have binary charset, so,
    simple charset recast binary->ucs2 was performed
    instead of real conversion.
    
    Fixed to make numbers pretend to be non-binary.
    
    
    mysql-test/r/ctype_ucs.result:
      Adding test case
    mysql-test/t/ctype_ucs.test:
      Adding test case
    sql/item_timefunc.cc:
      Adding new member from_cs, to replace my_charset_bin
      to a non-binary charset when converting from numbers to UCS2
    sql/item_timefunc.h:
      Adding new member from_cs, to replace my_charset_bin
      to a non-binary charset when converting from numbers to UCS2
    5c0c1dcc
item_timefunc.cc 73.4 KB