Hi Rick,
Yes, I think the script provided by you exhibites Derby behavior.
thanks,
Mamta
On Fri, Dec 16, 2011 at 12:58 PM, Rick Hillegas
wrote:
> Thanks, Mamta. That was very helpful. I think I am beginning to understand
> this better. At the end of this message I include a script which I belie
Thanks, Mamta. That was very helpful. I think I am beginning to
understand this better. At the end of this message I include a script
which I believe demonstrates the following:
1) The collation of string literals changes depending on your
compilation schema.
2) However, the collation of col
Hi Rick,
I haven't looked at the code but made a quick glance through the past
emails(from 2007) about collation discussion. And I think the
conclusion was to pick up the collation of the compilation schema for
character columns not coming from a table directly. I wrote test cases
for the 2 scenar
I have a couple questions about collations in Derby. As I understand it,
Derby supports two collations: UCS_BASIC and TERRITORY_BASED.
By default, all string types have UCS_BASIC collation and the string
columns in system catalogs always have UCS_BASIC collation regardless of
whether user tabl