Oracle Forms (MOSC)

MOSC Banner

SORTING PROBLEM

edited Dec 27, 2009 8:29PM in Oracle Forms (MOSC) 7 commentsAnswered
 Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center