Doesn't CHARACTER SET UNICODE_FSS solve the problem in one simple step? Am I
missing something?

-ST

----- Original Message -----
From: "Paul Beach" <pabeach@...>
To: <IBDI@onelist.com>
Sent: Wednesday, March 29, 2000 4:20 PM
Subject: Re: [IBDI] Character sets - for the IBDH database


> From: "Paul Beach" <pabeach@...>
>
> Ahhhh,
>
> > From: Helen Borrie <helebor@...>
> >
> > At 01:13 PM 29-03-00 +0100, you wrote:
> > >From: "Paul Beach" <pabeach@...>
> > >
> > >Helen,
> > >
> > >RTFM :-)
> >
> > Thanks a bunch, Paul.
>
> Couldn't resist it :-)
>
> >
> > >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>
> >
>
> You can't store rows in different character sets, if you think about it -
> you can see why its impossible, if we could do this we would have to be
able
> to determine on a row by row basis what its character set was, and since
we
> hold the information as part of the tables metadata, a column by column
> capability is as granualar as we can get.
>
> If you want it on a row by row basis, you are going to need seperate
tables.
>
> Regards
> Paul
>
>
>
>
> ------------------------------------------------------------------------
> Get a NextCard Visa, in 30 seconds!
> 1. Fill in the brief application
> 2. Receive approval decision within 30 seconds
> 3. Get rates as low as 2.9% Intro or 9.9% Fixed APR
> Apply NOW!
> http://click.egroups.com/1/2646/3/_/679568/_/954339157/
> ------------------------------------------------------------------------
>
> 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
>