OraFAQ Forum: Server Administration » which character set is suitable for Euro

Home » RDBMS Server » Server Administration » which character set is suitable for Euro

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which character set is suitable for Euro [message #321903]

Wed, 21 May 2008 15:22

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi to all,
I like to know which character set will support Euro in my database.

And national character set.

Thanks in Advance,

Seenu

Report message to a moderator

Re: which character set is suitable for Euro [message #321904 is a reply to message #321903]

Wed, 21 May 2008 15:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

>national character set.
Any particular National Character Set; or do I get to select which one?

[Updated on: Wed, 21 May 2008 15:24] by Moderator

Report message to a moderator

Re: which character set is suitable for Euro [message #321981 is a reply to message #321903]

Thu, 22 May 2008 00:41

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I like to know which character set will support Euro in my database.

Many.

Quote:

And national character set.

All of them.

Regards
Michel

Report message to a moderator

Re: which character set is suitable for Euro [message #322116 is a reply to message #321904]

Thu, 22 May 2008 09:36

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

The details of the database we are using is

NLS_NCHAR_CHARACTERSET UTF8
NLS_CHARACTERSET AL32UTF8
NLS_RDBMS_VERSION 9.2.0.8.0

The problem we have is to update the dollar symbol to Euro in one of the table. But when we use the shortcut key for Euro ALT+0128 we got only pipe symbol.

I have a doubt that Euro will support in the character set we use. Or please let me know the character sets that will support euro.

Thanks in Advance,

Seenu

Report message to a moderator

Re: which character set is suitable for Euro [message #322132 is a reply to message #321903]

Thu, 22 May 2008 10:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>please let me know the character sets that will support euro.

NLS_NCHAR_CHARACTERSET UTF8
NLS_CHARACTERSET AL32UTF8
NLS_RDBMS_VERSION 9.2.0.8.0

Might the problem be on the client/presentation side?

use UNISTR to "see" what actually is store in the database.

Report message to a moderator

Re: which character set is suitable for Euro [message #322134 is a reply to message #322132]

Thu, 22 May 2008 10:23

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

The problem we have is to update the dollar symbol to Euro in one of the table

Oh, that must be something! Let's imagine this "table" is a salary table. Let's imagine I'm in there, and my record looks like this:

EMP_NAME       SALARY    CURRENCY
-----------    ------    --------
Littlefoot     1000      $

Regarding current EUR/USD exchange rate (~0.6365), I'd be happy if you modified my salary from USD to EUR.

Report message to a moderator

Re: which character set is suitable for Euro [message #322444 is a reply to message #322132]

Fri, 23 May 2008 09:51

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi anacedent,
I will be thankful to you if you tell me in detail where to use UNISTR.

Thanks in Advance,

Seenu

Report message to a moderator

Re: which character set is suitable for Euro [message #322445 is a reply to message #322134]

Fri, 23 May 2008 09:57

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi Littlefoot,

I have updated from $ to �.
What i have done is,

Table Seems like this

EMP_NAME SALARY
----------- ------
Littlefoot $1000

When i type shortcut of Euro in Toad i get a pipe symbol. With that same i have executed, row is updated and i got euro symbol in the corresponding salary column

EMP_NAME SALARY
----------- ------
Littlefoot �1000

Thanks,

Seenu

Report message to a moderator