Advertisement

05.04.2004 at 08:38AM PDT, ID: 20977420
[x]
Attachment Details

Storing / Displaying EURO Symbol in Oracle 9i (and onwards)

Asked by Hilaire in Oracle Database

Tags: oracle, euro, symbol

Hi,
I'm stuck with this problem , although I'm not sure whether it's a display or a storing problem.
Oracle 9i on Win32 Platform, character set MSWIN1252

On Oracle previous version, I remember that some character (like WE8ISO 8859P15) sets were able to store the EURO symbo  (looks like a C with two horizontal bars in the middle)

My current Oracle box currently uses the MSWIN1252 character set, and I have no clue how to store / display this characters

I can insert chr(128) but it displays like a black square in SQL+
Is it that SQL+ can't display non-ascii characters, or am I using the wrong character set (I'm afraid I never had the choice during the install)

Any suggestions welcome

HilaireStart Free Trial
[+][-]05.04.2004 at 08:57AM PDT, ID: 10987984

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: oracle, euro, symbol
Sign Up Now!
Solution Provided By: slightwv
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.04.2004 at 09:31AM PDT, ID: 10988353

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.04.2004 at 09:34AM PDT, ID: 10988374

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32