[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