Hi!

Can I set case insensitive viewing in EDBManager?

I created GEN_ID named table, and I not found first.

But when I tried to create again, Manager failed.

The main problem that Manager showing the uppercase chars in the last section.

Thanks for your help:
  dd

durumdara


If I understand what you're asking for then when you create the table then for VARCHAR and CHAR columns there is a checkbox below the collation button which can be used to select that the column is case-insensitive. You can also do it in the query or filter by specifying a case-insensitive collation (look up COLLATE in the index).

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Dear Roy!

Sorry for my not understandable writings...

My problem that EDBManager show the tables with case sensitive order in the tree.
That's meaning when I created GEN_ID table, I see this in the end of the list.
I ask for an option where I can set that EDBManager list the objects as case insensitive mode
- this meaning, that GEN_ID table shown between "geg" and "get" tables, not after "zen-
buddhism" table (for example).

Thanks:
 dd


<<<
durumdara
If I understand what you're asking for then when you create the table then for VARCHAR and
CHAR columns there is a checkbox below the collation button which can be used to select that
the column is case-insensitive. You can also do it in the query or filter by specifying a case-
insensitive collation (look up COLLATE in the index).
Roy Lambert [Team Elevate]>>>

durumdara


Try

Explorer | Preferences | Explorer | Default Object Sort Order

set it to By Name

Roy Lambert