SORTING PROBLEM
I'm developing oracle forms 10.1.2.0.2 and I'm having a trouble in sorting varchar2 field alphabatically in french language. in english they are displayed correctly.
Example:
IN ENGLISH: (SELECT X from MY_TABLE ORDER BY X)
ABC00
ABC10
ABC20
ABCAA
ABCBB
IN FRENCH: (SELECT X from MY_TABLE ORDER BY X)
ABCAA
ABCBB
ABC00
ABC10
ABC20
I tried to use NLS_SORT=BINARY inside the default.env file but still not working. I tried to print the NLS_SORT value inside the form. I keep getting NLS_SORT=FRENCH . It looks like something is overriding the NLS_SORT value inside the default.env