support for multiple languages

Hi faculties,
I have a proposed application which should support two 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

jackal_on_work@yahoo.com wrote:
> Hi faculties,
> I have a proposed application which should support two 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.
jstucklex@attglobal.net
==================

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
> ==================

jackal_on_work@yahoo.com wrote:
> 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
>> ==================
>
>
> 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
>

(Top posting fixed)

Jackal,

Unless I'm missing something, I think you're looking at this the wrong
way. A database just stores information and delivers it on demand.

Determining which language is going to be displayed is not a database
function. You need to do that in whatever language you're using to
retrieve the data, and retrieve the appropriate data for your needs.

P.S. Please don't top post.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

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
> > ==================
>
>