Helen,

RTFM :-)

Its actually quite straight forward, InterBase is the only database that
will allow you to store multiple character sets within the same table. i.e.
it is possible to have multiple columns in a table that support different
character sets.

See Chapter 14 in the Data Definition Guide.

Another unique feature that we don't make enough noise about :-)


Paul Beach
Tel: US +1 831 431 6594
Tel: UK +44 (0)1844 354465
Mobile: +44 (0)7887 890375
E-Mail: pabeach@...

----- Original Message -----
From: Helen Borrie <helebor@...>
To: <ibdi@onelist.com>
Sent: Wednesday, March 29, 2000 12:59 PM
Subject: [IBDI] Character sets - for the IBDH database


> From: Helen Borrie <helebor@...>
>
> Help All!
>
> I'm storing all of the stuff for the IBDH in an SQL Server database....
>
> JUST KIDDING!
>
> ...in 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?
>
> Helen
> http://www.interbase2000.org
> ___________________________________________________
> "Ask not what your free, open-source database can do for you,
> but what you can do for your free, open-source database."
> (J.F.K.)
>
> ------------------------------------------------------------------------
> LOW RATE, NO WAIT!
> Get a NextCard Visa, in 30 seconds! Get rates
> as low as 2.9% Intro or 9.9% Fixed APR and no hidden fees.
> Learn more at:
> http://click.egroups.com/1/937/3/_/679568/_/954331012/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
>