Caused by: java.sql.SQLException: ORA-12899: 列 "WEB_DB"."WALLET_DETAILS"."RETMSG" 的值太大 (实际值: 233, 最大值: 150)
我自己写了一个工具类,精确截取字段的长度,防止入库时字段超长。
/**
* Created by Administrator on 20-2-19.
*/
public class SqlUtil {
private static final String sqlDefaultCharset = "GBK";
private static final String ISO88591 = "ISO-8859-1";
public static void main(String[] args) {
String string = "phil安卓asd中国";
System.out.println(SqlUtil.sub(string, 11));
System.out.println(SqlUtil.sub(string, 44));
}
/**
* 防止sql字段超长
* @param field
* @param len
* @return
*/
public static String sub(String field, int len){
try {
String safeString = new String(field.getBytes(sqlDefaultCharset), ISO88591);
System.out.println(safeString.length() + "" + new String(safeString.getBytes(ISO88591), sqlDefaultCharset));
if(safeString.length() > len){
String substring = safeString.substring(0, len);
String sqlField = new String(substring.getBytes(ISO88591), sqlDefaultCharset);
return sqlField;
}
return field;
} catch (Exception e) {
e.printStackTrace();
return "";
}
}
}
另一篇讲解一下String的编码问题
《扫除程序员的字符集编码障碍困惑》
https://blog.csdn.net/ZhaoHaiTang/article/details/104397678
参考博文:
《Java中英文字母汉字混合字符长度值计算》
https://blog.csdn.net/zhangphil/article/details/80505326?utm_source=distribute.pc_relevant.none-task