Search code examples
sqloracleoracle11goracle-sqldeveloper

Insert superscript letters into VARCHAR2 column specifically trademark symbol

I am trying to insert a superscript symbol, trademark into a VARCHAR2 column in Oracle SQL developer. I do not want to use NVARCHAR, which works.

I have tried using NVARCHAR as the type and it works but I can only use VARCHAR2.

CREATE TABLE TEST1 
   (    "DESCRIPTION_EN" VARCHAR2(500 CHAR)
   );

insert into test1 (  DESCRIPTION_EN) values ('Hello World ' || unistr('\2122') );

SELECT * FROM test1;

The trademark symbol as a superscript is the result I am looking for (™), yet I am seeing inverted question mark.

Solution

  • You cannot.

    WE8ISO8859P15 is the Oracle identifier for ISO-8859-15. That encoding that does not have the ™ symbol (aka U+2122 'TRADE MARK SIGN').

    That's precisely the issue that NVARCHAR came to solve ;-)

    Interestingly, you mention Windows-1252 and that encoding supports the symbol, but that isn't your database encoding.