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