ordering

[Stroeks]

Hello,

I am using query reporter, but i get some unexpected results in the ordering.

It seems that when i do an order by on a alfanumeric field, the order is not the same as in the same sql in plsql-developer.
For example order by in Query reporter ignores case. An also a '.' (dot) does not appear in the order.

So AAP, .BED, oeps, ZWAARD is the ordering i get when i order ascending.
(I expect .BED, AAP, ZWAARD, oeps)

Is this on purpose, or is it a bug, or can i change the ordering princip somewhere?

thnx,

Leo Soepenberg

 

[Marco Kalter]

I can only assume that the NLS_SORT and/or NLS_COMP settings are different for the Query Reporter and other tools that produce different results with the same query. This can happen if these tools are using a different Oracle Home, or if they are running on a different PC.

 

[Stroeks]

Marco

Thnx, i already thought so, we have multiple homes here, so it answers my question.

// Leo