postgreSQL中文排序的问题
时间:2011-07-27
来源:互联网
             安装时locale选择“chinese, singapore”,表的字符集选择“utf8”.
对中文排序时,果然像网上说的一样,排的乱七八糟。SQL和排序结果如下:
select '五指山' as a union select '三叉口' as a union
select '一线天' as a union select '二人转' as a union
select '四喜丸子' as a union select '六扇门' as a union
select '中文' as a union select '阿里山' as a union
select '宝贝' as a union select '茶叶' as a
order by a
"一线天"
"三叉口"
"中文"
"二人转"
"五指山"
"六扇门"
"四喜丸子"
"宝贝"
"茶叶"
"阿里山"
            
            对中文排序时,果然像网上说的一样,排的乱七八糟。SQL和排序结果如下:
select '五指山' as a union select '三叉口' as a union
select '一线天' as a union select '二人转' as a union
select '四喜丸子' as a union select '六扇门' as a union
select '中文' as a union select '阿里山' as a union
select '宝贝' as a union select '茶叶' as a
order by a
"一线天"
"三叉口"
"中文"
"二人转"
"五指山"
"六扇门"
"四喜丸子"
"宝贝"
"茶叶"
"阿里山"
作者: dangdang2471 发布时间: 2011-07-27
             查到一个据说可以解决此问题的方法,生成如下函数。但学生执行这段SQL是报错。。
create or replace function text2bytea(text) returns bytea as
$$
return $1;
$$ language plpgsql immutable;
报错内容:
ERROR: syntax error at or near "return"
LINE 3: return $1;
^
********** 错误 **********
ERROR: syntax error at or near "return"
SQL 状态: 42601
字符:74
            
            create or replace function text2bytea(text) returns bytea as
$$
return $1;
$$ language plpgsql immutable;
报错内容:
ERROR: syntax error at or near "return"
LINE 3: return $1;
^
********** 错误 **********
ERROR: syntax error at or near "return"
SQL 状态: 42601
字符:74
作者: dangdang2471 发布时间: 2011-07-27
 相关阅读 更多  
      
    热门阅读
-  
 office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
          阅读:74
 -  
 如何安装mysql8.0
          阅读:31
 -  
 Word快速设置标题样式步骤详解
          阅读:28
 -  
 20+道必知必会的Vue面试题(附答案解析)
          阅读:37
 -  
 HTML如何制作表单
          阅读:22
 -  
 百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
          阅读:31
 -  
 ET文件格式和XLS格式文件之间如何转化?
          阅读:24
 -  
 react和vue的区别及优缺点是什么
          阅读:121
 -  
 支付宝人脸识别如何关闭?
          阅读:21
 -  
 腾讯微云怎么修改照片或视频备份路径?
          阅读:28
 















