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