I have a simple table

```
 CREATE TABLE TRIAL 
   (    "COL" VARCHAR2(20 BYTE)
   )

```

and I insert there two values, '0', and 'A'. 

The query

```
select * from trial order by col

```

returns 

```
A
0

```

in this order, while the query

```
select * from trial where col>'A'

```

returns no results.
What could be the reason for such behaviour, and is there some simple trick, without changing db configuration, to get `order by` and `>` behave in a consistent manner?

**EDIT:**

to answer the comments:

```
select * from v$parameter where name like 'nls_sort'

```

returns

![](https://i.stack.imgur.com/ZCAFs.png)

and

```
select dump(col,16),col from trial

```

returns

```
Typ=1 Len=1: 30 0
Typ=1 Len=1: 41 A

```