-
有时候,保存文本时会输入一些表情符号，这些符号分为两种，一是由常见字符拼接成的，比如(*^▽^*)，o(╥﹏╥)o，还有一种就是直接的表情，比如展开全文
有时候,保存文本时会输入一些表情符号，这些符号分为两种，一是由常见字符拼接成的，比如
(*^▽^*)，o(╥﹏╥)o，还有一种就是直接的表情，比如?。两者传递到后端都能正确显示出来，如下：
但是在保存入库时，后者就会导致数据库操作发生错误：
Error updating database. Cause: java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x91\x87’ for column ‘content’ at row 1
The error may involve com.eknown.model.dao.mybatis.CommentDAO.save-Inline
The error occurred while setting parameters
SQL: INSERT INTO comment ( title, content, intervals, createTime, startTime, createUserId, eventsId ) VALUES ( ?, ?, ?, ?, ?, ?, ? )
Cause: java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x91\x87’ for column ‘content’ at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: ‘\xF0\x9F\x91\x87’ for column ‘content’ at row 1; nested exception is java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x91\x87’ for column ‘content’ at row 1] with root cause为什么呢？
根据上面的报错可以看出，是
?这个符号在转码后，与SQL语句发生了冲突。所以，我们需要对文本中的这类表情符号进行过滤。
下面的代码通过对String中的每一个字符进行遍历，判定是否是正常字符，如果是，则添加到结果集中：
/** * 过滤评论中所包含的表情符号 * @param str * @return */ public static String emojiFilter(String str) { try { Pattern pattern = Pattern.compile(unicodeReg); StringBuilder reBuffer = new StringBuilder(); for (int i = 0; i < str.length(); i++) { char c = str.charAt(i); String temp = String.valueOf(c); Matcher matcher = pattern.matcher(temp); if (matcher.find()) { reBuffer.append(temp); } } return reBuffer.toString(); } catch (Exception e) { e.printStackTrace(); return str; // 转换出错就放弃转换 } }正则匹配规则：
public final static String unicodeReg= "["+ "\u4E00-\u9FBF"+//：CJK 统一表意符号 (CJK Unified Ideographs) "\u4DC0-\u4DFF"+//：易经六十四卦符号 (Yijing Hexagrams Symbols) "\u0000-\u007F"+//：C0控制符及基本拉丁文 (C0 Control and Basic Latin) "\u0080-\u00FF"+//：C1控制符及拉丁：补充-1 (C1 Control and Latin 1 Supplement) "\u0100-\u017F"+//：拉丁文扩展-A (Latin Extended-A) "\u0180-\u024F"+//：拉丁文扩展-B (Latin Extended-B) "\u0250-\u02AF"+//：国际音标扩展 (IPA Extensions) "\u02B0-\u02FF"+//：空白修饰字母 (Spacing Modifiers) "\u0300-\u036F"+//：结合用读音符号 (Combining Diacritics Marks) "\u0370-\u03FF"+//：希腊文及科普特文 (Greek and Coptic) "\u0400-\u04FF"+//：西里尔字母 (Cyrillic) "\u0500-\u052F"+//：西里尔字母补充 (Cyrillic Supplement) "\u0530-\u058F"+//：亚美尼亚语 (Armenian) "\u0590-\u05FF"+//：希伯来文 (Hebrew) "\u0600-\u06FF"+//：阿拉伯文 (Arabic) "\u0700-\u074F"+//：叙利亚文 (Syriac) "\u0750-\u077F"+//：阿拉伯文补充 (Arabic Supplement) "\u0780-\u07BF"+//：马尔代夫语 (Thaana) //"\u07C0-\u077F"+//：西非书面语言 (N'Ko) "\u0800-\u085F"+//：阿维斯塔语及巴列维语 (Avestan and Pahlavi) "\u0860-\u087F"+//：Mandaic "\u0880-\u08AF"+//：撒马利亚语 (Samaritan) "\u0900-\u097F"+//：天城文书 (Devanagari) "\u0980-\u09FF"+//：孟加拉语 (Bengali) "\u0A00-\u0A7F"+//：锡克教文 (Gurmukhi) "\u0A80-\u0AFF"+//：古吉拉特文 (Gujarati) "\u0B00-\u0B7F"+//：奥里亚文 (Oriya) "\u0B80-\u0BFF"+//：泰米尔文 (Tamil) "\u0C00-\u0C7F"+//：泰卢固文 (Telugu) "\u0C80-\u0CFF"+//：卡纳达文 (Kannada) "\u0D00-\u0D7F"+//：德拉维族语 (Malayalam) "\u0D80-\u0DFF"+//：僧伽罗语 (Sinhala) "\u0E00-\u0E7F"+//：泰文 (Thai) "\u0E80-\u0EFF"+//：老挝文 (Lao) "\u0F00-\u0FFF"+//：藏文 (Tibetan) "\u1000-\u109F"+//：缅甸语 (Myanmar) "\u10A0-\u10FF"+//：格鲁吉亚语 (Georgian) "\u1100-\u11FF"+//：朝鲜文 (Hangul Jamo) "\u1200-\u137F"+//：埃塞俄比亚语 (Ethiopic) "\u1380-\u139F"+//：埃塞俄比亚语补充 (Ethiopic Supplement) "\u13A0-\u13FF"+//：切罗基语 (Cherokee) "\u1400-\u167F"+//：统一加拿大土著语音节 (Unified Canadian Aboriginal Syllabics) "\u1680-\u169F"+//：欧甘字母 (Ogham) "\u16A0-\u16FF"+//：如尼文 (Runic) "\u1700-\u171F"+//：塔加拉语 (Tagalog) "\u1720-\u173F"+//：Hanunóo "\u1740-\u175F"+//：Buhid "\u1760-\u177F"+//：Tagbanwa "\u1780-\u17FF"+//：高棉语 (Khmer) "\u1800-\u18AF"+//：蒙古文 (Mongolian) "\u18B0-\u18FF"+//：Cham "\u1900-\u194F"+//：Limbu "\u1950-\u197F"+//：德宏泰语 (Tai Le) "\u1980-\u19DF"+//：新傣仂语 (New Tai Lue) "\u19E0-\u19FF"+//：高棉语记号 (Kmer Symbols) "\u1A00-\u1A1F"+//：Buginese "\u1A20-\u1A5F"+//：Batak "\u1A80-\u1AEF"+//：Lanna "\u1B00-\u1B7F"+//：巴厘语 (Balinese) "\u1B80-\u1BB0"+//：巽他语 (Sundanese) "\u1BC0-\u1BFF"+//：Pahawh Hmong "\u1C00-\u1C4F"+//：雷布查语(Lepcha) "\u1C50-\u1C7F"+//：Ol Chiki "\u1C80-\u1CDF"+//：曼尼普尔语 (Meithei/Manipuri) "\u1D00-\u1D7F"+//：语音学扩展 (Phone tic Extensions) "\u1D80-\u1DBF"+//：语音学扩展补充 (Phonetic Extensions Supplement) "\u1DC0-\u1DFF"+//结合用读音符号补充 (Combining Diacritics Marks Supplement) "\u1E00-\u1EFF"+//：拉丁文扩充附加 (Latin Extended Additional) "\u1F00-\u1FFF"+//：希腊语扩充 (Greek Extended) "\u2000-\u206F"+//：常用标点 (General Punctuation) "\u2070-\u209F"+//：上标及下标 (Superscripts and Subscripts) "\u20A0-\u20CF"+//：货币符号 (Currency Symbols) "\u20D0-\u20FF"+//：组合用记号 (Combining Diacritics Marks for Symbols) "\u2100-\u214F"+//：字母式符号 (Letterlike Symbols) "\u2150-\u218F"+//：数字形式 (Number Form) "\u2190-\u21FF"+//：箭头 (Arrows) "\u2200-\u22FF"+//：数学运算符 (Mathematical Operator) "\u2300-\u23FF"+//：杂项工业符号 (Miscellaneous Technical) "\u2400-\u243F"+//：控制图片 (Control Pictures) "\u2440-\u245F"+//：光学识别符 (Optical Character Recognition) "\u2460-\u24FF"+//：封闭式字母数字 (Enclosed Alphanumerics) "\u2500-\u257F"+//：制表符 (Box Drawing) "\u2580-\u259F"+//：方块元素 (Block Element) "\u25A0-\u25FF"+//：几何图形 (Geometric Shapes) "\u2600-\u26FF"+//：杂项符号 (Miscellaneous Symbols) "\u2700-\u27BF"+//：印刷符号 (Dingbats) "\u27C0-\u27EF"+//：杂项数学符号-A (Miscellaneous Mathematical Symbols-A) "\u27F0-\u27FF"+//：追加箭头-A (Supplemental Arrows-A) "\u2800-\u28FF"+//：盲文点字模型 (Braille Patterns) "\u2900-\u297F"+//：追加箭头-B (Supplemental Arrows-B) "\u2980-\u29FF"+//：杂项数学符号-B (Miscellaneous Mathematical Symbols-B) "\u2A00-\u2AFF"+//：追加数学运算符 (Supplemental Mathematical Operator) "\u2B00-\u2BFF"+//：杂项符号和箭头 (Miscellaneous Symbols and Arrows) "\u2C00-\u2C5F"+//：格拉哥里字母 (Glagolitic) "\u2C60-\u2C7F"+//：拉丁文扩展-C (Latin Extended-C) "\u2C80-\u2CFF"+//：古埃及语 (Coptic) "\u2D00-\u2D2F"+//：格鲁吉亚语补充 (Georgian Supplement) "\u2D30-\u2D7F"+//：提非纳文 (Tifinagh) "\u2D80-\u2DDF"+//：埃塞俄比亚语扩展 (Ethiopic Extended) "\u2E00-\u2E7F"+//：追加标点 (Supplemental Punctuation) "\u2E80-\u2EFF"+//：CJK 部首补充 (CJK Radicals Supplement) "\u2F00-\u2FDF"+//：康熙字典部首 (Kangxi Radicals) "\u2FF0-\u2FFF"+//：表意文字描述符 (Ideographic Description Characters) "\u3000-\u303F"+//：CJK 符号和标点 (CJK Symbols and Punctuation) "\u3040-\u309F"+//：日文平假名 (Hiragana) "\u30A0-\u30FF"+//：日文片假名 (Katakana) "\u3100-\u312F"+//：注音字母 (Bopomofo) "\u3130-\u318F"+//：朝鲜文兼容字母 (Hangul Compatibility Jamo) "\u3190-\u319F"+//：象形字注释标志 (Kanbun) "\u31A0-\u31BF"+//：注音字母扩展 (Bopomofo Extended) "\u31C0-\u31EF"+//：CJK 笔画 (CJK Strokes) "\u31F0-\u31FF"+//：日文片假名语音扩展 (Katakana Phonetic Extensions) "\u3200-\u32FF"+//：封闭式 CJK 文字和月份 (Enclosed CJK Letters and Months) "\u3300-\u33FF"+//：CJK 兼容 (CJK Compatibility) "\u3400-\u4DBF"+//：CJK 统一表意符号扩展 A (CJK Unified Ideographs Extension A) "\u4DC0-\u4DFF"+//：易经六十四卦符号 (Yijing Hexagrams Symbols) "\u4E00-\u9FBF"+//：CJK 统一表意符号 (CJK Unified Ideographs) "\uA000-\uA48F"+//：彝文音节 (Yi Syllables) "\uA490-\uA4CF"+//：彝文字根 (Yi Radicals) "\uA500-\uA61F"+//：Vai "\uA660-\uA6FF"+//：统一加拿大土著语音节补充 (Unified Canadian Aboriginal Syllabics Supplement) "\uA700-\uA71F"+//：声调修饰字母 (Modifier Tone Letters) "\uA720-\uA7FF"+//：拉丁文扩展-D (Latin Extended-D) "\uA800-\uA82F"+//：Syloti Nagri "\uA840-\uA87F"+//：八思巴字 (Phags-pa) "\uA880-\uA8DF"+//：Saurashtra "\uA900-\uA97F"+//：爪哇语 (Javanese) "\uA980-\uA9DF"+//：Chakma "\uAA00-\uAA3F"+//：Varang Kshiti "\uAA40-\uAA6F"+//：Sorang Sompeng "\uAA80-\uAADF"+//：Newari "\uAB00-\uAB5F"+//：越南傣语 (Vi?t Thái) "\uAB80-\uABA0"+//：Kayah Li "\uAC00-\uD7AF"+//：朝鲜文音节 (Hangul Syllables) //"\uD800-\uDBFF"+//：High-half zone of UTF-16 //"\uDC00-\uDFFF"+//：Low-half zone of UTF-16 "\uE000-\uF8FF"+//：自行使用区域 (Private Use Zone) "\uF900-\uFAFF"+//：CJK 兼容象形文字 (CJK Compatibility Ideographs) "\uFB00-\uFB4F"+//：字母表达形式 (Alphabetic Presentation Form) "\uFB50-\uFDFF"+//：阿拉伯表达形式A (Arabic Presentation Form-A) "\uFE00-\uFE0F"+//：变量选择符 (Variation Selector) "\uFE10-\uFE1F"+//：竖排形式 (Vertical Forms) "\uFE20-\uFE2F"+//：组合用半符号 (Combining Half Marks) "\uFE30-\uFE4F"+//：CJK 兼容形式 (CJK Compatibility Forms) "\uFE50-\uFE6F"+//：小型变体形式 (Small Form Variants) "\uFE70-\uFEFF"+//：阿拉伯表达形式B (Arabic Presentation Form-B) "\uFF00-\uFFEF"+//：半型及全型形式 (Halfwidth and Fullwidth Form) "\uFFF0-\uFFFF]";//：特殊 (Specials);
qq_28379809 2019-04-29 14:42:10 -
如何从字符串中删除表情符号我的简单代码是..public static void main(String[] args) throws SQLException {String str="My nam is ur -D ";getRefineCode(str);}private static void getRefineCode(String str) ...展开全文
如何从字符串中删除表情符号我的简单代码是..
public static void main(String[] args) throws SQLException {
String str="My nam is ur -D ";
getRefineCode(str);
}
private static void getRefineCode(String str) throws {
List smstypeWord=getshortWord();
for(int i=0;i
String string=smstypeWord.get(i).toString();
String stringcon[]=string.split("_");
String emessage=stringcon[0];
String emoticon=stringcon[1].trim();
if(str.contains(emoticon)) {
str=str.replace(emoticon, emessage);
System.out.println("=================>"+str);
}
}
System.out.println("=======++==========>"+str);
}
private static List getshortWord() throws SQLException {
String query1 = "SELECT * FROM englishSmsText";
PreparedStatement ps = conn.prepareStatement(query1);
ResultSet rs = ps.executeQuery();
String f_message="";
String s_message="";
while(rs.next()) {
s_message=rs.getString("message");
f_message=rs.getString("short_text");
shortMessage.add(s_message+"_"+f_message);
//fullMessage.add(f_message);
}
return shortMessage;
}我的数据库基于http://smsdictionary.co.uk/abbreviations网站
我能够理解如何删除多个abb。或短消息
输出就像我的纳姆是你SquintLaughtGrinisappGaspoooh !! shockedintedr，Big SmilGrinisappGaspoooh !! shockedinted，Grin
weixin_42508215 2021-03-17 12:58:44 -
因为表情符号是四个字节，数据库中utf8是三个字节，所以存入sql数据库会报错 解决办法一： 直接修改数据库字符集编码格式 把utf8格式改成utf8mb4的格式就可以了 这样表情符号就可以直接存入数据库了 解决办法二： 不...展开全文
因为表情符号是四个字节，数据库中utf8是三个字节，所以存入sql数据库会报错
解决办法一：
直接修改数据库字符集编码格式
把utf8格式改成utf8mb4的格式就可以了
这样表情符号就可以直接存入数据库了解决办法二：
不改变数据库从代码的层次来解决
1、在pom.xml文件中引入jar包：<dependency> <groupId>com.github.binarywang</groupId> <artifactId>java-emoji-converter</artifactId> <version>1.0.0</version> </dependency>2、在需要存入数据库的时候进行转码处理
```java EmojiConverter emojiConverter = EmojiConverter.getInstance(); String alias=emojiConverter.toHtml(ccMcsWechatUsersBo.getNickName()); ccMcsWechatUsersBo.setNickName(alias);实际名称样式： 存入数据库的样式： 🍦🎤🛀 💕 极夜 在vue前端项目中我们现实用户名 ```java <p class="name" >{{item.customerNickName}}</p>实际现实的样式
我们需要在标签中加入v-html 属性<p class="name" v-html="item.customerNickName">{{item.customerNickName}}</p>加入后显示：
因为toHtml方法是转换成html code存放在数据库，在html中会自动转换成原来的表情（这一点是非常棒的！！）省了再转码的步骤
还有，如果直接想在js中完成转码也可以
//字符串转成表情 funcodeUtf16 (str){ var reg = /\&#.*?;/g; var result = str.replace(reg,function(char){ var H,L,code; if(char.length == 9 ){ code = parseInt(char.match(/[0-9]+/g)); H = Math.floor((code-0x10000) / 0x400)+0xD800; L = (code - 0x10000) % 0x400 + 0xDC00; return unescape("%u"+H.toString(16)+"%u"+L.toString(16)); }else{ return char; } }); return result; },然后直接引用这个方法处理一下就可以了，就可以显示原来的表情了
ccyj1024 2020-06-18 15:44:48 -
如：名称???? 会过滤成名称 public class EmojiCharUtils { ... * 转换emoji表情特殊字符的方法 * @param chars * @return */ public static String transform(String chars){ if (StringUtils.isEmpt...展开全文
如：名称😃 会过滤成名称 public class EmojiCharUtils { /** * 转换emoji表情特殊字符的方法 * @param chars * @return */ public static String transform(String chars){ if (StringUtils.isEmpty(chars)){ return chars; } StringBuilder emojiChars = new StringBuilder(); int l = chars.length(); for (int i = 0; i < l; i++) { char _s = chars.charAt(i); if (isEmojiCharacter(_s)) { emojiChars.append(_s); } } return emojiChars.toString(); } public static boolean isEmojiCharacter(char codePoint) { return (codePoint == 0x0) || (codePoint == 0x9) || (codePoint == 0xA) || (codePoint == 0xD) || ((codePoint >= 0x20) && (codePoint <= 0xD7FF)) || ((codePoint >= 0xE000) && (codePoint <= 0xFFFD)) || ((codePoint >= 0x10000) && (codePoint <= 0x10FFFF)); } }如果你是湖南的 欢迎加入 湖南人在深圳-Java群：557651502
lv_hang515888 2020-01-07 15:38:59 -
weixin_35476604 2021-04-22 00:59:30
-
weixin_28921115 2021-06-18 12:44:09
-
weixin_34513260 2021-01-27 01:57:51
-
a944750471 2018-09-12 14:02:07
-
culunxun2863 2020-09-11 10:40:03
-
qq_44799924 2021-05-21 11:46:26
-
qing_gee 2018-04-26 18:37:14
-
weixin_33755554 2019-04-26 17:16:00
-
qq_37022150 2018-01-11 12:07:40
-
weixin_45649244 2020-07-13 17:28:32
-
weixin_36411884 2021-03-11 14:56:58
-
weixin_42266267 2021-02-12 15:01:21
-
weixin_35412669 2021-02-27 18:20:01
-
BuFanQi_Info 2018-02-02 16:23:23
-
qq_39723363 2019-10-25 11:13:59
-
aizhupo1314 2018-11-12 15:11:12
-
weixin_31181381 2021-03-22 11:02:47
-
w13528476101 2018-07-03 09:31:31
-
GodTao111 2021-08-27 10:47:43
java
订阅