Re: Multilingual database

Thank you very much for your patience. May I have one
more question?

May I put the login and password of my customers in
the same table containing my customers name and
address?

Thanks in advance
Terence Ng

--- "M. Bastin" <marcbastin(at)mindspring(dot)com> wrote: >
At 11:12 AM +0800 5/13/03, Terence Ng wrote:
> >I see. Thank you very much. But I have come up
> >another question. For the language-dependent
> >information, there is a code to differentiate each
> >record, and every column has the same language.
>
>
> No! One single column contains all descriptions,
> regardless of their language!
> If you'd have a column per language, then you'd get
> into the same
> kind of problems as when you'd have a table per
> language.
>
> Example:
>
> CODE LANGUAGE DESCRIPTION
> x123 French frites surgeles
> x123 English frozen french fries
> z456 French gaufres belges
> z456 English belgian waffles
>
> > What
> >if I expand my web site, allowing customers from
> >different countries lookup their orders. How do I
> >record their information if I allow them to
> register
> >their info in their languages? For example, I will
> >have customer_id and customer_name. How do I
> record
> >customer_name? Is it a good practice if I create
> >every language a column, with customer_id as a
> >relation?
>
> Your customer data is probably not language
> dependent. One table
> should be enough.
>
> Example:
>
> ID LAST NAME FIRST NAME GENDER LANGUAGE ADDRESS
> 101 Dupont Louis m French ... France
> 102 Jones Tina f English ... USA
>
> The way you present this information on screen
> should be in the
> customer's language, but each bit of customer
> information you
> actually want to store, is unique per customer, and
> the language is
> not relevant: a last name is just always a last
> name, whether the
> person speaks French or English.
>
> Marc
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

_______________________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk