Subject Character sets - for the IBDH database
Author Helen Borrie
Help All!

I'm storing all of the stuff for the IBDH in an SQL Server database....

JUST KIDDING! an IB database. All was sweet until it hit me like a rock that I
need to store text of different character sets in the one database, nay,
within the same tables. The database is structured on the OpenDoc XML tree
- at the top level is the SET (name BookSET) beneath which is BOOK - one
row for each language.

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

(Boy, this is a challenge!)

Dave Schnepper, are you out there?

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