case when then then后中文显示问号
时间: 2023-10-21 09:20:53 浏览: 104
在case when语句中,当then后的中文显示问号,可能是由于字符集设置不正确导致的。可以通过执行以下命令来查看字符集设置的相关信息:show variables like 'character_set_%';
通过上述命令可以获取到字符集相关的设置信息。
如果字符集设置不正确,可能需要修改相关参数来正确显示中文字符。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [sql小技巧之case when](https://blog.csdn.net/weixin_46300771/article/details/122200388)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [MySQL 查询语句中自己定义的中文内容在Java Web 中显示为问号](https://blog.csdn.net/weixin_36452281/article/details/113267753)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文