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