Hi!
I was trying to build derby since last two days. It was a breeze
without eclipse. With eclipse it took quite a while and still not
successful.
Following articles and mailing list threads did help
(1) http://wiki.apache.org/db-derby/BuildingDerby
(2) http://mail-archives.apache.org/mod_mbox/d
I made some more comments on case-insensitivity:
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12607439#action_12607439
-geoff
---The content of this email is confidential.---
Suavi Ali Demir wrote:
for case insensitive index, you can have another column that holds lower-case
version of your original column. you can create an index on that lowercase
column and use it in your sql. you can use triggers to maintain the lowercase
column.
Something like this seems to
for case insensitive index, you can have another column that holds lower-case
version of your original column. you can create an index on that lowercase
column and use it in your sql. you can use triggers to maintain the lowercase
column.
ali
--- On Mon, 6/23/08, Alan Burlison <[EMAIL PROTECTE
Bryan Pendleton wrote:
I store my critical string fields twice, in two separate columns, one
column has the user-desired case, and the other column has the same data
in all upper case.
Then, when I want to search without considering case, I take my search
terms, convert them to all upper case,
How do people work around this at present? I absolutely *must* have
case-insensitive indexed searches in my application.
I store my critical string fields twice, in two separate columns, one
column has the user-desired case, and the other column has the same data
in all upper case.
Then, when
Rick Hillegas wrote:
I have commented on the issue. Your latest proposal sounds to me like
DERBY-455 (expression indexes). That would be a very elegant, powerful
feature but I think that DERBY-481 (generated columns) entails less
effort and gives us most of the power of expression indexes. As
Hi,
I need a query to restrict the row count in derby. luckily it got
implemented in derby 10.4.1.3 but there are few limitations.
one of the limitations as follows..
---
http://db.apache.org/derby/docs/dev/ref/rreffuncrownumber.html
the above doc is saying, *we cant use where clause along wi
Geoff hendrey wrote:
I posted a comment with a suggestion on an approach for dealing with
case-insensitive comparisons.
Any feedback?
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166
Hi Geoff,
I have commented on the issue. Your latest proposal sound
Geoff hendrey wrote:
I posted a comment with a suggestion on an approach for dealing with
case-insensitive comparisons.
Any feedback?
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166
I find declaring the collation when defining the column is much more
I posted a comment with a suggestion on an approach for dealing with
case-insensitive comparisons.
Any feedback?
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166
11 matches
Mail list logo
