IMHO, Unicode is the only way to go. It supports all national character
sets that have been mapped (except possibly vogon) so the entire
question of "Which character set" goes away. The only question that
remains for internationalized databases is "which country's collation
specification do I use", and that can best be determined at runtime.

I believe that they fixed the issues with unicode in FB2. The
internationalized collation actually converts data to unicode internally
before sorting under some circumstances.

I Hope this helps.

On Tue, 2006-03-14 at 11:47 +0000, Ian A. Newby wrote:
> Hi Folks,
> I've been using FB since its first beta release and have always used
> character set none (I am English and didn't need the hassle of
> anything else.)
>
> With the advent of FB 2, with the new international engine, and the
> talk that FB 3+ is likely to go native unicode, what is the "best"
> character set/collation to use for English (UK) for firebird 2? I'm in
> the process of migrating an application from firebird 1.5 to 2 and
> this could be the best time to do a character set conversion.
>
> Wbat benefits are there to using a character set other than none?
>
> What pitfalls are there?
>
> Regards
> Ian Newby
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>