We did something similar, if I get your needs right.

If you are sure that there are only two languages to be supported, just make
two attributes for every text that needs to be localised. Ether use dynamic
sql or use the client side to decide wich text top display.

Another approach would be to use a language table and child tables for every
table which needd localised info:
- link to parent
- localised text 1
....
- link to language

So you can support multiple languages. Take care of missing translations, as
it is then a bad idea to display nothing....

hth

bernd

<jackal_on_work@yahoo.com> schrieb im Newsbeitrag
news:1171870387.669590.103400@k78g2000cwa.googlegr oups.com...
> Hi,
> Thanks for the reply. I agree to what you have mentioned. Yes, there
> are lots of changes on the GUI side such as displaying of screen
> lables. But if I need to display data from a table, e.g some product
> information, then we will have to fetch it from database. And
> depending on the user he will be able to view in on the front-end. A
> Spanish user will be able to view it in Spanish and while for others
> same product information will come in English.
>
> So can you advise, how can I achive this functionality on the
> database side?
>
> Thanks and Regards
> Jackal Hunt
>
> On Feb 5, 6:44 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> > jackal_on_w...@yahoo.com wrote:
> > > Hi faculties,
> > > I have a proposed application which shouldsupporttwo languages:
> > > Spanish and US English. The data will be stored in MySQL database. We
> > > will be having a single database. Can you please suggest about
> > > possible configurations needed to be done at the database side to
> > > accomplish this?
> >
> > > Thanks in advance
> > > Jackal
> >
> > Nowhere near enough information to help you with this.
> >
> > In fact, the first question I would have is - why use a MySQL (or any
> > other) database? There are many ways to make a program multi-lingual.
> >
> > --
> > ==================
> > Remove the "x" from my email address
> > Jerry Stuckle
> > JDS Computer Training Corp.
> > jstuck...@attglobal.net
> > ==================
>
>