Hi again.

I can't find at the documentation how create index with "case sensitive", by default it
create "case insensitive"

Thank you

Francisco

In ElevateDB there is no "case insensitive" index like DBISAM has, you can
search the help for collations at field level or even create an index with
special collation "CI".

Eduardo

Francisco


If you're using EDBManager then when you add a column to the index you're given the option of selecting a collation and a number of parameters. One of those is case-insensitive check/uncheck this as needed

If you're doing it in code then add the collation information after each field eg

ALTER INDEX "ContactName"
ON "Contacts"
("_Surname" COLLATE "ANSI_CI" ASC,"_Forename" COLLATE "ANSI_CI" ASC,"_Soundex" COLLATE "ANSI_CI" ASC)

Roy Lambert [Team Elevate]

ps

When using EDBManager check out Explorer - SQL History

Hi again.

In ElevateDB manager i can check "Case-Insensitive" but i don't obtain by code. I'm creating index as the example
but the check "Case-Insensitive" remains marked when i go to ElevateDB manager.

Solved. I was take the example of SQL History from ElevateDB manager and it work.

Thank you all.

Francisco


I think, but I don't know without looking at the code, that the case-insensitive checkbox when you add a new column depends on the collation for the column. But it seems that once its set the only way to alter it is to drop the column from the index and add it back in.

Roy Lambert

Roy,

<< I think, but I don't know without looking at the code, that the
case-insensitive checkbox when you add a new column depends on the collation
for the column. But it seems that once its set the only way to alter it is
to drop the column from the index and add it back in. >>

This is a bug in the EDB Manager.  I'll make sure it's fixed for the next
build.

--
Tim Young
Elevate Software
www.elevatesoft.com