Skip to main content
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.
LinkedIn
Copied!

Table of Contents

Euro symbol support in Oracle

Symptom

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.

 

 

Solution

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

WWWhttp://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/nchar/readme.html

Article originally written 7/30/2007.

Suggest Edit
Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us