替换MYSQL中的非ASCII字符 [英] Replace NonASCII Characters in MYSQL

问题描述

要将非ASCII字符转换为ASCII，我使用了以下查询

To convert NON ASCII Characters to ASCII I used the below query

UPDATE tablename
SET columnToCheck = CONVERT(columnToCheck USING ASCII)
 WHERE columnToCheck <> CONVERT(columnToCheck USING ASCII)

它将NON ASCII字符替换为替换字符.但是可以将那些非Ascii字符替换为SPACES.

It replaces the NON ASCII characters into replacement characters. But is it possible to replace those Non Ascii characters to SPACES.

我尝试了一些选项，但是它不起作用.有任何建议.

I tried some options, but its not working. Any suggestion.

推荐答案

尝试一下

UPDATE tablename
SET columnToCheck = REPLACE(CONVERT(columnToCheck USING ascii), '?', '')
WHERE ...

或

update tablename
set columnToCheck = replace(columnToCheck , char(146), '');

参考

这篇关于替换MYSQL中的非ASCII字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！