Subject Re: [IBDI] Character sets - for the IBDH database
Author Paul Beach

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