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?
|