SORTING 中文 IN ORACLE - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SORTING 中文 IN ORACLE

SORTING 中文 IN ORACLE# Database - 数据库

n*a2000-06-29 07:06

1 楼

哪位大侠知道怎么SORTING 中文 IN ORACLE。我试用
select field1 from globaltest where language
= 'Simplified Chinese' order by NLSSORT(field1,
'NLS_SORT=Chinese');
得到了一个ERROR，ORA-12702: invalid NLS parameter string
used in SQL function
先谢了

s*k2000-06-29 07:06

2 楼

Oracle now only support binary sort for Eastern Languages
included Chinese.
So for Chinese try:
select field1 from globaltest where language
= 'Simplified Chinese' order by NLSSORT(field1,
'NLS_SORT=binary');

【在 n*****a 的大作中提到】

: 哪位大侠知道怎么SORTING 中文 IN ORACLE。我试用
: select field1 from globaltest where language
: = 'Simplified Chinese' order by NLSSORT(field1,
: 'NLS_SORT=Chinese');
: 得到了一个ERROR，ORA-12702: invalid NLS parameter string
: used in SQL function
: 先谢了

n*a2000-06-29 07:06

3 楼

So if needed, how can it be done for sorting? external?
Do you know where can get any package to do it?

【在 s*k 的大作中提到】

:
: Oracle now only support binary sort for Eastern Languages
: included Chinese.
: So for Chinese try:
: select field1 from globaltest where language
: = 'Simplified Chinese' order by NLSSORT(field1,
: 'NLS_SORT=binary');

s*k2000-06-29 07:06

4 楼

In fact binary sort is a sort according to the binary
value of the double bytes character. If you are dissatisfied
with the result, I think you may have to sort by external
programs or pl/sql package of you own.
By far, I don't know where you can get the package.

【在 n*****a 的大作中提到】

: So if needed, how can it be done for sorting? external?
: Do you know where can get any package to do it?