> 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.

Sorting? Oh, I forgot that. Collations are for sorting, of course. You
will get correct results for ORDER BY as well. However, for English
I think you won't notice a big difference ;-)

When your web page has "windows-1252" as it character set you can echo
out the strings from the database directly.
That's what you put in the <head> of your HTML:
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

Note that in HTML the identifier is 'windows-1252', whereas in
Firebird it's 'WIN1252'. Both mean the same thing (HTML [and also XML]
use the official IANA/MIME code).


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird