Steve:
You aren't missing anything IMHO. This charset must support all national
characters... at least in theory.

However, don't ask me if a COLLATE has sense after storing strings from
different languages.
;-)

The only cost is as you know better than me that each UNICODE will use two
or three bytes per each unicode-char, so you db grows faster and indexes are
more limited in their length.

C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.xoom.com/cvalde

> -----Original Message-----
> From: Steve Tendon [mailto:steve@...]
> Sent: Miércoles 29 de Marzo de 2000 13:29
> To: IBDI@onelist.com
> Subject: Re: [IBDI] Character sets - for the IBDH database
>
>
> From: "Steve Tendon" <steve@...>
>
> 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
> >
>
>
> ------------------------------------------------------------------------
> Good friends, school spirit, hair-dos you'd like to forget.
> Classmates.com has them all. And with 4.4 million alumni already
> registered, there's a good chance you'll find your friends here:
> http://click.egroups.com/1/2623/3/_/679568/_/954350783/
> ------------------------------------------------------------------------
>
> 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
>