Professional Web Applications Themes

UCase and German characters - Macromedia ColdFusion

Environment: CFMX- Oracle-Windows XP I'm querying my database for records that matched the German character "?" (If you dont see this character properly, open up your Windows Word and hold the the "ctrl" and "shift" keys then hit " & " Let up on all keys, then type "s" .) But before doing my search, I UCase the input string. Unfortunately UCase converts it to "SS" and my query does not return the expected results.. Anyone seen this happening ?...

  1. #1

    Default UCase and German characters

    Environment: CFMX- Oracle-Windows XP

    I'm querying my database for records that matched the German character "?" (If
    you dont see this character properly, open up your Windows Word and hold the
    the "ctrl" and "shift" keys then hit " & " Let up on all keys, then type "s" .)

    But before doing my search, I UCase the input string. Unfortunately UCase
    converts it to "SS" and my query does not return the expected results..

    Anyone seen this happening ?

    netuser Guest

  2. #2

    Default Re: UCase and German characters

    there is no upper case form of "sharp s" so cf is replacing it with ss (which i
    think is a rule, i do know that capital case ? was proposed & rejected by the
    unicode consortium). can't the oracle query be made case-insensitive?



    PaulH Guest

  3. #3

    Default Re: UCase and German characters

    Paul

    Thanks for your response. I can make the query case-insensitive, but I have a
    lot of code written which already use UCase. Dint want to impact existing code
    just for 1 character.

    If the character has been rejected by Unicode consortium, I wonder why Oracle
    returns UPPER('?') as ?.

    Do you know of any other characters that would have this problem ?

    Thanks in Advance.

    netuser Guest

  4. #4

    Default Re: UCase and German characters

    oracle has always gone it's own way--there simply isn't an upper case ? and ss
    is the rule for when you can't use ?--so in this case i guess oracle's wrong in
    what it's doping (though this might be just a case of one of its many chts
    behavior).

    as far as i recall that's the only char w/out an upper case form, of course
    that's not counting languages w/out any kind of upper case like thai, etc. but
    if i get a chance i'll poke around w/icu4j's UCharacter class to see what's
    what. what langauges are you dealing with?


    PaulH Guest

  5. #5

    Default Re: UCase and German characters

    i tested this using icu4j's UCharacter class (using no locale and de_DE locale)
    and it returns the same thing as cf/core java, SS for upper case ?. i didn't
    have time to run thru many enumerations of captial letters but that appears to
    be the only one w/out an upper case form.

    <cfscript>
    uChar=createObject("java","com.ibm.icu.lang.UChara cter");
    germanLocale=createObject("java","com.ibm.icu.util .ULocale").init("de_DE");
    sharpS=chr(223);
    writeoutput("<b>no locale:</b> #sharpS# #uChar.toUpperCase(sharpS)#
    #uChar.toLowerCase(sharpS)#<br>");
    writeoutput("<b>de_DE locale:</b> #sharpS#
    #uChar.toUpperCase(germanLocale,sharpS)#
    #uChar.toLowerCase(germanLocale,sharpS)#<br>");
    </cfscript>

    PaulH Guest

Similar Threads

  1. Need to insert German characters regularly
    By palurie in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 3
    Last Post: June 12th, 04:52 PM
  2. Problems with special german characters
    By Gizmo in forum IBM DB2
    Replies: 0
    Last Post: September 15th, 09:17 PM
  3. file i/o with german characters
    By caseymanx webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 0
    Last Post: September 13th, 07:43 PM
  4. Replies: 1
    Last Post: August 12th, 03:28 PM
  5. Replies: 3
    Last Post: July 9th, 10:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139