[Info-vax] AlphaVM-free emulator with all additional peripheral components
Paul Sture
paul at sture.ch
Fri Aug 3 06:12:00 EDT 2012
On Thu, 02 Aug 2012 12:46:00 -0500, Bob Koehler wrote:
> In article <seqe9-3b5.ln1 at news1.chingola.ch>, Paul Sture <paul at sture.ch>
> writes:
>>
>> "The collating sequence of lower case alphabetic characters is higher
>> than upper case and numerics are higher still — the exact opposite of
>> ASCII."
>>
>> The collating sequence got me at one stage. I was wondering if we had
>> enough disk space to sort a very large input file into ASCII sequence,
>> then it occurred to me to do two passes up the file outputting the
>> numerics first.
>
> Since A .lt. B depends on the charaacter set, Fortran added functions
> to compare characters according to the ASCII collating sequence quite
> a while ago.
>
> All the ASCII based systems I had access to since then support the
> new functions. I haven't had to look at IBM's Fortran in decades,
> but the last time I did that part of the Fortran standard was
> documented by IBM as unsupported on thier EBCDIC based mainframes.
>
> So the one place you really needed them, you got to roll your own.
Great eh?
Did you realise that the default collating sequence for MySQL is
latin1_swedish_ci?
http://www.sitebuddy.com/mssql_info/
mysql_character_sets_and_collation_explained
"The default server level can be change in your my.ini configuration file
with the directive default-character-set (--default-character-
set=character_set_name and ). If not specific the default is latin1. And
the default collation for latin1 is latin1_swedish_ci"
And um, I wanted to quote from the official MySQL documentation there but
Oracle have merged its search function into the rest of their products
and I ended up with a load of PL/SQL hits.
--
Paul Sture
More information about the Info-vax
mailing list