java 执行 select concat(ID,'测试') case WHEN Type=0 then '免费' else '收费' end ,name from tb_Test;
==========
1测试 ???????? 张三
2测试 ???????? 李四
数据库编码:
"character_set_client","gb2312"
"character_set_connection","gb2312"
"character_set_database","gbk"
"character_set_filesystem","binary"
"character_set_results","gb2312"
"character_set_server","gbk"
"character_set_system","utf8"
"character_sets_dir","C:\\Program Files\\MySQL\\MySQL Server 5.1\\share\\charsets\\"为什么 concat 显示 中文, case部分显示的就是乱码呢
==========
1测试 ???????? 张三
2测试 ???????? 李四
数据库编码:
"character_set_client","gb2312"
"character_set_connection","gb2312"
"character_set_database","gbk"
"character_set_filesystem","binary"
"character_set_results","gb2312"
"character_set_server","gbk"
"character_set_system","utf8"
"character_sets_dir","C:\\Program Files\\MySQL\\MySQL Server 5.1\\share\\charsets\\"为什么 concat 显示 中文, case部分显示的就是乱码呢
MySQL 中文显示乱码
select ...
我的语句是 CASE WHEN SEX=1 THEN '男' ELSE '女' END
CASE WHEN SEX=1 THEN '男' WHEN SEX=2 THEN '女' END
上边两句都出乱码
而我写成 CASE WHEN SEX=1 THEN '男' WHEN SEX=2 THEN '女' ELSE '' END 就OK了
所以我建议你改成 select concat(ID,'测试') case WHEN Type=0 then '免费' CASE WHEN TYPE =1 THEN '收费' else '' end ,name from tb_Test;