oracle char字符

1. char是定长的，所以在插入的时候一定要设计好其长度，否则只能插入部分的内容；

2. sql语句查询char类型的时候，要把他转化成varchar类型，否则只会查出一个字符；

public List getSQLByPlaceCode(String placeCode) {
String sql = "SELECT a.BACKUPFILEID , cast(a.GUID as varchar2(36)), a.FILETYPE, a.FILENAME, a.FILESIZE, a.STATUS, a.LOCALBACKUPTIME, a.CREATETIME  "
+ "FROM feePlaceDBBackupRecord a , basPlace b where a.placeID = b.placeID and b.placeCode = "+placeCode + " and   a.STATUS='7' order by a.LOCALBACKUPTIME";
String mStr = "";
String retSQL = sql;
SQLQuery aSQLQuery = getSession().createSQLQuery(retSQL);
List list = aSQLQuery.list();
return list;
}