| Sort [message #203511] |
Wed, 15 November 2006 06:17  |
vatsjai
Messages: 23
Registered: May 2005
Location: delhi
|
Junior Member |
|
|
Hello to all oracle gurus
Hi
I have a problem regarding sort. I have a table with data in punjabi(india punjab language) and it is converted into english alphabets.I have entered this data into table by forms.
I want to sort this table with this columnwise. How i can do that please suggest something urgently.
Jai
|
|
|
|
|
|
| Re: Sort [message #203552 is a reply to message #203513] |
Wed, 15 November 2006 08:53  |
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
|
Senior Member |
|
|
hi,
r u entring data into Punjabi?? and Oracle is converting it in English.
|
|
|
|
| Re: Sort [message #203817 is a reply to message #203552] |
Thu, 16 November 2006 07:38 |
vatsjai
Messages: 23
Registered: May 2005
Location: delhi
|
Junior Member |
|
|
hi
I enter data in a text box with punjab font. so it shows data in punjabi but when i commit_form then it is posted in oracle table.
Oracle does not suppor alphabet (ura,erra in punjab) so it converts them in english alphabets. If i sort on this column then it will sort form a to z which is not my requirments.I hope u do understand?
Jai
|
|
|
|
| Re: Sort [message #203820 is a reply to message #203817] |
Thu, 16 November 2006 07:43 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
In other words, front end (your form) uses one font (according to regional settings you have set), but database uses another - different - NLS setting. Am I wrong or not?
Oracle sorts data using an ORDER BY clause. What happens if you set your database to use required NLS? I don't know which one it is, but *suppose* that there must exist one that will suit your needs.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
