[Info-vax] AlphaVM-free emulator with all additional peripheral components

[Jan-Erik Soderholm]

Paul Sture wrote 2012-08-03 12:12:
> 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.
>

How is the "granulatity" of collating sequences in MySQL ?

In Rdb, you can set specific collating seqences on table and field level.
I once used this to get an automatic "sort" on a serial code field that
used A-Z and 0-9 "in reverse" as the numbering. In this case there was
no builtin collating sequence but that was easily added using the standard
OpenVMS (not Rdb specific) tools and then referenced from the Rdb
CREATE TABLE command.

Jan-Erik.