Helen,

Just from top of my head...

How about separate columns for each language (with right charset
specification used on column) ? Maybe you should better create a separate
table for each (former) column ?

Best regards

From: "Helen Borrie" <helebor@...>

> We go down levels, storing DIVISION, PART, CHAPTER and several different
> kinds of components, with several language-specific text columns along the

way.

>
> Is there a magic wand solution for this, other than storing the
> language-specific content in lookup tables in separate databases? I hope

so...