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