[askdba] Re: how do i change default character set

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Sat, 2 Apr 2005 12:17:18 -0700

You can identify the database character set and national character set
with the query

select *
  from v$nls_parameters
 where parameter like '%CHARACTERSET%'

What are your database and national character sets?  What characters do
you want to encode?

Justin Cave  <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of drumil narayan
Sent: Saturday, April 02, 2005 2:49 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] how do i change default character set

dear all

how do i check my database support multilinguial
characters and if not supporting what should i do so
that it will suport.

thanx inadvance..drumil

--- Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
> Subodh,
>=20
> U need to Have all the Languages stored in the
> Database. Or Use some
> Funky piece of software that will translate stuff
> for you .. I am not
> sure if one is available.
>=20
> :)
> Rgds
> Ganesh
>=20
>=20
> On Thu, 24 Mar 2005 08:42:04 -0500, Subodh Deshpande
> <subodh_deshpande@xxxxxxxxx> wrote:
> > thanx ganesh,
> >=20
> > please put some more light..
> >=20
> > my query is data inserted in Italian langauage
> should be visible in other l=3D
> > anguages and vice versa..
> >=20
> > will AL16UTF16 NLS character set and datatype
> NCHAR or NVARCHAR is suffcient
> >=20
> > thanx..subodh
> > ----- Original Message -----
> > From: "Ganesh Raja" <ganesh.raja@xxxxxxxxx>
> > To: askdba@xxxxxxxxxxxxx
> > Subject: [askdba] Re: Multilingual Support
> > Date: Thu, 24 Mar 2005 13:11:41 +0000
> >=20
> > >=3D20
> > > U need to maintain all this data in the
> database..
> > >=3D20
> > >=3D20
> > > On Thu, 24 Mar 2005 08:02:18 -0500, Subodh
> Deshpande
> > > <subodh_deshpande@xxxxxxxxx> wrote:
> > > > Dear All,
> > > >
> > > > How do achieve, say data will be inserted in
> Italian and can be retrive=3D
> > d in=3D3D
> > > > any language.
> > > >
> > > > i.e. a data inserted in italian person should
> be visible in japanaese, =3D
> > chin=3D3D
> > > > ese, english language and vice versa.
> > > >
> > > > what exactly i will have to do for this..
> > > >
> > > > thanx in advance..take care
> > > >
> > > > Good Luck..Subodh Deshpande
> > > >
> >=20
> > Good Luck..Subodh Deshpande
> >=20
> >
>
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
=3D3D=3D
> >
>
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
> > Experience Is Knowledge
> > Wisdom Is Philosophy
> >
>
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
=3D3D=3D
> >
>
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D
> >=20
> > --=3D20
> > _______________________________________________
> > NEW! Lycos Dating Search. The only place to search
> multiple dating sites at=3D
> > once.
> > http://datingsearch.lycos.com
> >=20
> >
>=20
>=20

________________________________________________________________________
Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony


Other related posts: