1 Reply Latest reply: May 14, 2013 3:23 PM by Greg Spall RSS

    Decompose

    Greg Spall
      Hey was hoping somebody could straighten me out :)

      I'm looking at this function: DECOMPOSE, on an 11.2 database:

      http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions050.htm#SQLRF00632

      The example in there shows this:
      SELECT DECOMPOSE ('Châteaux')
        FROM DUAL; 
      
      DECOMPOSE
      ---------
      Cha^teaux
      When I try that, however, I get this:
       SELECT DECOMPOSE ('Châteaux')
         2   FROM DUAL; 
      
      DECOMPOS
      --------
      Châteaux
      Now, I know it says "results vary depending on character set"... great .. but that doesn't really help.

      My character set is: WE8ISO8859P1
      My NLS NCHAR character set is: AL16UTF16

      I'm on a Linux system ..

      LANG=en_US.UTF-8
      NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

      So, why doesn't it strip it? Is it because the character set fully supports it? so it thinks it doesn't need to?

      [edit]
      Oh O_0 . never mind .. just noticed this in the first line of the documentation - sigh
      DECOMPOSE is valid only for Unicode characters.
      [edit]

      Edited by: Greg.Spall on May 14, 2013 4:20 PM

      Edited by: Greg.Spall on May 14, 2013 4:21 PM