Subodh, 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. :) Rgds Ganesh On Thu, 24 Mar 2005 08:42:04 -0500, Subodh Deshpande <subodh_deshpande@xxxxxxxxx> wrote: > thanx ganesh, > > please put some more light.. > > my query is data inserted in Italian langauage should be visible in other l= > anguages and vice versa.. > > will AL16UTF16 NLS character set and datatype NCHAR or NVARCHAR is suffcient > > 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 > > U need to maintain all this data in the database.. > >=20 > >=20 > > 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= > d in=3D > > > any language. > > > > > > i.e. a data inserted in italian person should be visible in japanaese, = > chin=3D > > > ese, english language and vice versa. > > > > > > what exactly i will have to do for this.. > > > > > > thanx in advance..take care > > > > > > Good Luck..Subodh Deshpande > > > > > Good Luck..Subodh Deshpande > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Experience Is Knowledge > Wisdom Is Philosophy > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > --=20 > _______________________________________________ > NEW! Lycos Dating Search. The only place to search multiple dating sites at= > once. > http://datingsearch.lycos.com > >