0 Replies Latest reply on Aug 23, 2013 7:48 PM by 1000877

    Japanese character in Code Editor of "View" is shown as Question Marks

    1000877

      Hi All,

      I have a probelm where I tried to create a view having decode function as shown below:

       

      decode(A.resource_process_name,

              'ザイコ', 'Inventory',

              'PP良後', 'Wafer BE',

              'PP良前', 'Wafer FE',

              'PP良済', 'Wafer',

              'PP良引', 'Wafer in transit',

              A.resource_process_name

        ) as step_code

       

      Data type of A.resource_process_name is NVARCHAR2. Data in "STEP_CODE" column is displayed correctly after translation using decode function when I run select statement of this view. I don't have any issue till this point.

       

      But problem happens when I try to see/open the script/code of this view in the SQL Developer (Right click view --> Edit...). It shows me the code of decode function as shown below:

       

      decode(A.resource_process_name,

              '¿¿¿', 'Inventory',

              'PP¿¿', 'Wafer BE',

              'PP¿¿', 'Wafer FE',

              'PP¿¿', 'Wafer',

              'PP¿¿', 'Wafer in transit',

              A.resource_process_name

        )

       

      Can you please suggest whay should be done so that the code should be visible in it is original format i.e., it should show decode function with Japanese characters?