记录下SQL的trim方法,全角空格在两个数据库同时运作。
原SQL
select * trim (chr(‘ ’) from 字段名) as 字段名 from 表名;
新SQL
select * trim(chr(33088) from 字段名)as 字段名 from 表名;
例子:
create table user(
id varchar(8) not null,
name varchar(10),
constraint user primary key (id)
);
select * trim(chr(33088) from name) as name from user;