Subject Re: [IBDI] Character sets - for the IBDH database
Author Helen Borrie
At 10:07 PM 29-03-00 +0000, you wrote:
>From: Glebas Paulevicius <glebas@...>
>At 11:25 PM 3/29/00 +1000, you wrote:
> >From: Helen Borrie <helebor@...>
> >
> >Nope, that's not the problem. I need different ROWS in the same table
> >having different charsets.
>Why don't you keep it simple - use a column per language -
>there are definitely finite set of languages out there.

No, that doesn't solve it as I don't know how many or which languages will
be in there eventually. I must retain the ability to add more books as
time goes by. Actually, it would be like drawing teeth to make me design a
"cross-tab" structure like this. Lookup tables are the obvious option and
I have no objection to them.

On further pondering, I decided it has other benefits also, as it gives me
an easy route to populating the actual data from external tables (once I
get the interface side of things sorted out).

"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."