..oO(Amit Jain)

>[multiple languages]
>Now I want to store Name and Description in other language so suggest/
>idea how my table look.
>
>Destination:->
>----------------------------------------------------------------------------------------------------------------------------
>DestID Name Description GermanName
>GermanDescription
>-----------------------------------------------------------------------------------------------------------------------------

Bad idea. For adding another language you would have to alter the table
structure.

>or
>
>DestinationMaster:->This table store content in English language
>--------------------------------------------------------------------
>DestID Name Description
>--------------------------------------------------------------------
>
>DestinationGerman:->This table store content in Geraman language
>-------------------------------------------------------------------
>DestID Name Description
>-------------------------------------------------------------------
>
>DestinationDutch:->This table store content in Dutch language
>------------------------------------------------------------------
>DestID Name Description
>------------------------------------------------------------------

Even worse (IMHO).

A third idea: Add a field 'lang' for storing a language code (2 or 5
chars). Make that the primary key together with the DestID field. Then
store one record for each language.

Micha