Euro symbol support in Oracle
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
For more information on NVARCHAR2 datatype as it relates to Oracle, see
Article originally written 7/30/2007.