Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Euro symbol support

Euro symbol support

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Fri, 26 Jan 2001 10:20:17 -0500
Message-Id: <10753.127583@fatcity.com>


Here's a nasty problem: Many databases, all with character set WE8ISO8859P1, which does not support the Euro symbol. It looks like we need to convert to WE8ISO8859P15 or WE8MSWIN1252 to get Euro support. The ALTER DATABASE CHARACTER SET ... command doesn't work because the target character set is not a superset of the source set, so it seems that it is necessary to recreate the databases and exp/imp. Anyone know of a less painful way to get there from here? Databases are 8.1.5 and 8.1.7 on both Sun and NT.

Also, anyone have any advice on which character set to choose, WE8ISO8859P15, WE8MSWIN1252 or any other? I'm thinking WE8MSWIN1252, because according to Metalink, Forms versions before 6i don't support WE8ISO8859P15, and there are some Forms 4.5 apps here.

Much thanks,

Gary Kirsh
Next Extent, Inc Received on Fri Jan 26 2001 - 09:20:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US