Home » RDBMS Server » Server Administration » which character set is suitable for Euro
which character set is suitable for Euro [message #321903] Wed, 21 May 2008 15:22 Go to next message
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
Re: which character set is suitable for Euro [message #321904 is a reply to message #321903] Wed, 21 May 2008 15:24 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: which character set is suitable for Euro [message #322116 is a reply to message #321904] Thu, 22 May 2008 09:36 Go to previous messageGo to next message
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

Re: which character set is suitable for Euro [message #322132 is a reply to message #321903] Thu, 22 May 2008 10:13 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: which character set is suitable for Euro [message #322134 is a reply to message #322132] Thu, 22 May 2008 10:23 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: which character set is suitable for Euro [message #322444 is a reply to message #322132] Fri, 23 May 2008 09:51 Go to previous messageGo to next message
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
Re: which character set is suitable for Euro [message #322445 is a reply to message #322134] Fri, 23 May 2008 09:57 Go to previous messageGo to next message
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

Re: which character set is suitable for Euro [message #322461 is a reply to message #322444] Fri, 23 May 2008 10:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UNISTR

Regards
Michel
Re: which character set is suitable for Euro [message #322479 is a reply to message #322461] Fri, 23 May 2008 12:44 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Thank u Michel
Previous Topic: ORA-04030 during stress testing
Next Topic: cannot allocate new log sequence
Goto Forum:
  


Current Time: Sun Dec 04 14:34:58 CST 2016

Total time taken to generate the page: 0.09908 seconds