charset display error

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago in General Permalink

ver:9.4.0.5216 display ok, from 9.4.0.5217 display error

2 attachment(s):
  • QQ-20161123104054
  • QQ-20161123104143
ansgar's profile image ansgar posted 7 years ago Permalink

Your post + screenshots reference to 4 different revision. Please provide a more exact description of the problem, and the output of CREATE VIEW xyz here.

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

ver:9.4.0.5126 SELECT value_date, value_type, block_code, MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 运行小时, MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `最高负荷 FROM kpi_sctj_value GROUP BY value_date, value_type, block_code

ver:9.4.0.5127 SELECT value_date, value_type, block_code, MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 杩愯灏忔椂, MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `鏈€楂樿礋鑽穈 FROM kpi_sctj_value GROUP BY value_date, value_type, block_code

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

ver:9.4.0.5126 SELECT value_date, value_type, block_code, MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 运行小时, MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `最高负荷 FROM kpi_sctj_value GROUP BY value_date, value_type, block_code

ver:9.4.0.5127 SELECT value_date, value_type, block_code, MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 杩愯灏忔椂, MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `鏈€楂樿礋鑽穈 FROM kpi_sctj_value GROUP BY value_date, value_type, block_code

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

o,sorry

ansgar's profile image ansgar posted 7 years ago Permalink

Hm, the CREATE code also has these chinese characters. Seems your VIEW is broken for some reason.

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

I test in python:

print '杩愯灏忔椂'.decode('utf-8')

output: 运行小时

'运行小时' is correct.

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

charset decode error? my mysql: character_set is 'gbk'

[expired user #7236]'s profile image [expired user #7236] posted 7 years ago Permalink

but ver:9.4.0.5126(and before) correct.

Please login to leave a reply, or register at first.