Lou,

there is some information about character set issues on my website at
http://www.destructor.de/firebird/charsets.htm

I have also given a talk about character sets at the last Firebird
Conference in Prague, the slides can be found here:
http://www.destructor.de/talks/index.htm

For English language applications, you can use either ISO8859_1 or
WIN1252 as character set. When your clients only run Windows, you may
be better off using WIN1252. For clients in the US, you can/should use
the EN_US collation for this character set.

From my understanding, it should be possible to copy NONE strings to
WIN1252 without any problems. As your users used Windows so far,
everything is practically already stored in this format. The collation
will give you the ability to do case insensitive searches and get
correct results from the UPPER() function.


Best Regards

Stefan

> Hi.

> I have been using Firebird with Delphi apps for some time now. I
> always have created my databases with the default Charset of NONE and
> just go about my way. Now I am wondering if perhaps I should be using
> some otherdefault character set to avert some future problem I may be
> creating for myself using NONE. My clients are in the US, speak
> english and all run on Win32 (2000,XP). I would appreciate any tips
> and suggestions as to which charset and collation is a good default
> choice. What do I do to move current data from "NONE" charset toa new
> charset?

> Thanks.

> - Lou

> I am primarily using Firebird 1.5 (and using FB2 Beta for internal
> development projects).







> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> 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

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links



>

--
Stefan Heymann
www.destructor.de/firebird