n*****a
发帖数: 10 | 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*k
发帖数: 144 | 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*****a
发帖数: 10 | 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*k
发帖数: 144 | 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?
|
