Thanks for replies.

I also am starting to do some PHP on Linux and Win32 with Firebird
hosted on Linux and/or Win32. Will explore WIN1252 a bit as the
possiblity of case insensitive searches (what about sorting?) sounds
potentially useful.

Cheers!

- Lou

--- In firebird-support@yahoogroups.com, Stefan Heymann <lists@...> wrote:
>
> 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
>