[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12546341 ] Mamta A. Satoor commented on DERBY-2967: Kathey, I did a quick review of the release note and it looks good.

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12545630 ] Mamta A. Satoor commented on DERBY-2967: Kathey, thanks for trying to resolve the problem with release notes

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12542846 ] Kathey Marsden commented on DERBY-2967: --- Can this issue be resolved? Single character does not match high

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539108 ] Laura Stewart commented on DERBY-2967: -- I have opened Derby-3166 as a doc issue for this dev issue. My

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536705 ] Knut Anders Hatlen commented on DERBY-2967: --- When you said even though 'aa' = 'å' in Norwegian territory,

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536768 ] Mamta A. Satoor commented on DERBY-2967: Knut, yes, I did mean the SQL = operation. Also, thanks for your

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536792 ] Knut Anders Hatlen commented on DERBY-2967: --- Thanks Mamta, that makes sense. I am wondering if anyone

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536570 ] Mamta A. Satoor commented on DERBY-2967: The coding for this jira entry is over(I have created a new jira

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536170 ] Knut Anders Hatlen commented on DERBY-2967: --- Thanks for pointing me to the right part of the standard,

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535953 ] Mamta A. Satoor commented on DERBY-2967: Migrated changes from trunk(revision 585261) into 10.3(revision

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535958 ] Mamta A. Satoor commented on DERBY-2967: Thanks, Knut, for checking my commit. I was hesitant too about all

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535972 ] Knut Anders Hatlen commented on DERBY-2967: --- According to the javadoc for CollationElementIterator,

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535974 ] Knut Anders Hatlen commented on DERBY-2967: --- Another simple way to cut down the string allocations... I

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535975 ] Mamta A. Satoor commented on DERBY-2967: Knut, I really like the last suggestion because it will keep the

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535987 ] Knut Anders Hatlen commented on DERBY-2967: --- One more question: In the discussion above, I see that the

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535993 ] Knut Anders Hatlen commented on DERBY-2967: --- I just realized how confusing my comment must have been... :)

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536004 ] Mamta A. Satoor commented on DERBY-2967: Knut, we can not ignore the collation and just compare the

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536105 ] Mamta A. Satoor commented on DERBY-2967: I have entered jira entry DERBY-3136 to improve on object

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535479 ] Knut Anders Hatlen commented on DERBY-2967: --- I read the Oct 11 patch in the commit log and I have a

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535339 ] Mamta A. Satoor commented on DERBY-2967: Committed(revision 585261) DERBY2967_Oct11_07_diff.txt into main

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533401 ] Daniel John Debrunner commented on DERBY-2967: -- Actually I think the correct terminology for this is

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533306 ] Bernt M. Johnsen commented on DERBY-2967: - Mamta, you are right. SQL spec Section 4.2.2 also defines the

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533310 ] Bernt M. Johnsen commented on DERBY-2967: - I also agree that even if 'aa'='å' should be true with Norwegian

Re: [jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

Mamta A. Satoor (JIRA) wrote (2007-10-04 13:25:50): So, the question is, in say Norwegian, what do we call AA? Is it a character or something else? Unicode specificaiton has a concept of text elemenets and characters (http://www.unicode.org/versions/Unicode5.0.0/ch02.pdf Unicode chapter 2

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533261 ] Mamta A. Satoor commented on DERBY-2967: Bernt Johnsen made following comments on the derby dev list Mamta

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533263 ] Mamta A. Satoor commented on DERBY-2967: Bernt, I tend to disagree with 'aa'='å' is false statement based on

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532518 ] Mamta A. Satoor commented on DERBY-2967: I spent some time on Unicode specification and SQL specification in

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532155 ] Daniel John Debrunner commented on DERBY-2967: -- The SQL Standard also specifies what a single

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12531956 ] Daniel John Debrunner commented on DERBY-2967: -- Looking carefully at the SQL Standard - section 8.5 SR

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12529493 ] Mamta A. Satoor commented on DERBY-2967: Kathey, I am looking at the escape character problem. Single

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12528994 ] Mamta A. Satoor commented on DERBY-2967: Kathey, I am trying to see if I can rewrite my code using

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12528131 ] Kathey Marsden commented on DERBY-2967: --- Mamta, will running with Sun JVM's cause the existing functionality

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527398 ] Mamta A. Satoor commented on DERBY-2967: I talked with Dan briefly on my last patch(temp_diff.txt) and found

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527628 ] Mamta A. Satoor commented on DERBY-2967: The patch submitted by me will not work on Sun's jdks (I have

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523324 ] Mamta A. Satoor commented on DERBY-2967: I do not have any numbers for the performance results for int array

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12523073 ] Daniel John Debrunner commented on DERBY-2967: -- Are there any numbers for the performance benefit seen

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12522039 ] Mamta A. Satoor commented on DERBY-2967: I spent some time on this Jira entry to explore Dan's suggestion

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12519120 ] Kathey Marsden commented on DERBY-2967: --- Below are the results run against DB2 v8.2 with UCA400_NO collation.

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518548 ] Kathey Marsden commented on DERBY-2967: --- Dan said: As for implementing it, I think one has to use the

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518575 ] Daniel John Debrunner commented on DERBY-2967: -- How about this to skip one logical character (not

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518204 ] Kathey Marsden commented on DERBY-2967: --- I am looking at the current behavior where _ matches a single

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518262 ] Daniel John Debrunner commented on DERBY-2967: -- I would say neither (existing or proposed) is correct,

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518264 ] Kathey Marsden commented on DERBY-2967: --- Both String.length() and SQL LENGTH say agraveCombined =A\u0300 is

[jira] Commented: (DERBY-2967) Single character does not match high value unicode character with collation TERRITORY_BASED

[ https://issues.apache.org/jira/browse/DERBY-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518269 ] Daniel John Debrunner commented on DERBY-2967: -- String.length() returning two matches its definition so