Subject Re: [IBDI] Character sets - for the IBDH database
Author Helen Borrie
At 01:13 PM 29-03-00 +0100, you wrote:
>From: "Paul Beach" <pabeach@...>
>
>Helen,
>
>RTFM :-)

Thanks a bunch, Paul.

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

Nope, that's not the problem. I need different ROWS in the same table
having different charsets.


>See Chapter 14 in the Data Definition Guide.

What I want isn't there.

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

YOU said that. <g>

Helen


>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
> >
> >
>
>
>------------------------------------------------------------------------
>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.
>Apply NOW!
>http://click.egroups.com/1/2122/3/_/679568/_/954331454/
>------------------------------------------------------------------------
>
>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

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