1

Can anybody suggest me that what is the meaning of 'U' in the below conditional Index.

CREATE UNIQUE INDEX "MDM"."CITY_xx" 
   ON "MDM"."CITY" ( REGEXP_REPLACE (UPPER("CITY_NAME"),U'[@ $=:;0-9.,_-]',NULL), "COUNTRY_ID", "STATE_ID")
a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
Amit
  • 21
  • 1
  • 1
    From elsewhere on stackoverflow: `U'` is used to handle the SQL NCHAR String Literals in Oracle Call Interface (OCI). There is no practical difference to `N'` for nvarchars. [nstring vs ustring](https://stackoverflow.com/questions/48076425/difference-between-nstring-vs-ustring-literals-in-oracle) – Adder Dec 05 '19 at 15:37

0 Answers0