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

  • From: drumil narayan <drumilnarayan@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Mon, 4 Apr 2005 15:20:20 +0100 (BST)

Hello Justine,

the character set is WE8ISO8859P1, where as nchar set
is AL16UTF16.

I want to store french, german, english, Hindi
(India's National Langauage)

will it support...

if not what exactly i will have to do to accomodate
this change, there is no restriction on making any
change at database side as this is just installed and
even sample data is to be uploaded into it.

thanking you inadvance..drumil

--- "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx> wrote:
> 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
> 
> 
> 

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

Other related posts: