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

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

Article originally written 7/30/2007.