Re: how 2: storing special characters

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1 Feb 2002 11:27:56 -0800
Message-ID: <a20d28ee.0202011127.742d6122@posting.google.com>

"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message news:<a3e98p$17k9ao$1_at_ID-54600.news.dfncis.de>...
> no, does not work
>
> "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
> news:3c59b2f6$1_1_at_mk-nntp-1.news.uk.worldonline.com...
> > Steffen,
> > IIRC, character set WE8ISO8851P9 should be OK, unless you need umlauts and
> > so forth as well.
> > HTH,
> > Paul
> >
> > "Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message
> > news:a3bjv3$16vkro$1_at_ID-54600.news.dfncis.de...
> > > i wanna save an Euro-sign (?) into an oracle database
> > >
> > > which possebilities do i have?
> > >
> > > nvarchar?
> > > characters set of the db?
> > > nls?
> > >
> > > where can i find a simple and short explanation?
> > >
> > >
> >
> >

There is an article up on www.oramag.com on this issue and Metalink also has info Basically

- your database has to use WE8ISO8859P15
- your codepage has to be MSWIN1252
- you can only use certain fonts
- of course NLS_LANG in your registry has to be changed

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 01 2002 - 13:27:56 CST