Re: Oracle 7.x with Nordic Languages (NLS_LANG)

beyond just installing with an appropriate character set to encompass to the local languages you're interested in (WE8ISO8859P1 should work for European stuff), you _must_ set NLS_LANG appropriately on the client side for the language the session is going to be using.

I install all my databases using WE8ISO8859P1, even if they're just going to be used in the U.S. makes life easier if things shift... if the client/data is for the U.S.,

  NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 which is _not_ going to allow entry of non-U.S. characters, Swedish for instance. for a Swedish client/data,

  NLS_LANG=SWEDISH_SWEDEN.WE8ISO8859P1 the character set is still the same (it's the character set of the server, but the client can now correctly insert/select Swedish characters. but probably wouldn't do German entirely well (I'm assuming there must be _some_ differences, probably wouldn't get an S-set right).

for that US7ASCII instance, you're pretty much out of luck for anything but U.S. English.

hope that helps.

• mark

In article <01bdcf9a$a32a1800$6ffbffc2_at_jw>,   "Jens Waldorff" <waldorff_at_danbbs.dk> wrote:
> On Windows NT we use WE8ISO8859P1 for a Danish character set.
> On VMS we use a DEC... character set.
>
> Jens Waldorff
>
> gsurya_at_rocketmail.com skrev i artiklen <6rr886$56v$1_at_nnrp1.dejanews.com>...
> > Which is the correct character set to use Oracle 7.x with Nordic
> Languages,
> > viz. Danish, Norgegian, Swedish and Finnish? I have installations using
> both
> > US7ASCII and WE8ISO8859P1 and both are having some peculiar problems.
> >
> > Applications running are Baan and others on the same database. Any other
> care
> > I must take when using Norwegian characters in the database?
> >
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 11:38:27 CDT