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