官网地址:http://www.sql-workbench.eu/
在mysql中显示空间字段类型
在用户的home目录下的 .sqlworkbench 目录下的workbench.settings 中添加这句
workbench.db.mysql_5_7.selectexpression.point=AsText(${column}) ${column}
这句是怎么来的呢?
在DbSettings.java中添加下面这句,跟踪过来的
每个列都可以通过表达式或者转换函数来解决显示的问题,关键是找到这个key值,然后配置进去即可
LogMgr.logInfo(nci,"---------------------"+prefixFullVersion + prop);
private String getVersionedString(String prop, String defaultValue)
{
Settings set = Settings.getInstance();
CallerInfo nci = new CallerInfo(){};
LogMgr.logInfo(nci,"---------------------"+prefixFullVersion + prop);
System.err.println("---------------------"+prefixFullVersion + prop);
String result = set.getProperty(prefixFullVersion + prop, NOT_THERE);
if (result != NOT_THERE) return result;
result = set.getProperty(prefixMajorVersion + prop, NOT_THERE);
if (result != NOT_THERE) return result;
if (aliasSettings == null)
{
return set.getProperty(prefix + prop, defaultValue);
}
result = set.getProperty(prefix + prop, NOT_THERE);
if (result == NOT_THERE)
{
return aliasSettings.getVersionedString(prop, defaultValue);
}
return result;
}