Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Euro symbol support in Oracle

Updated on September 13, 2021


The Euro symbol (€) stored in the database is not being retrieved properly. The symbol appears as an upside down question mark in the clipboard and displays on the screen in this format.




This issue is due to the symbol being stored in a column with datatype VARCHAR2. This datatype column stores the Euro symbol, but does not convert it to the equivalent hexadecimal code.

To properly convert the Euro symbol in your database so it displays properly in Process Commander, you must store it in a column of datatype NVARCHAR2.

The NVARCHAR2 datatype is a variable-length character data having maximum length n characters or bytes, depending on the national character set. The maximum length is determined by the number of bytes required to store each character, with an upper limit of 4,000 bytes. You must specify the maximum length for NVARCHAR2 columns

For more information on NVARCHAR2 datatype as it relates to Oracle, see


Article originally written 7/30/2007.

  • Previous topic Decimal numbers are stored incorrectly by some Oracle drivers in Java 5
  • Next topic How to estimate disk space requirements for a PegaRULES database (Oracle)

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us