alphanumeric and special character sorting

Posted by Kaushik Gopal on Stack Overflow See other posts from Stack Overflow or by Kaushik Gopal
Published on 2010-05-06T08:54:33Z Indexed on 2010/05/06 8:58 UTC
Read the original article Hit count: 707

Filed under:

sorting

|

alphanumeric

|

sql

|

database

|

standards

Hi ppl,

I wanted to know the different standards of sorting. To be more specific take the sample set:

(Please note there's capitals, small letters, special characters, null values and numbers here)

A
a
3F
Zx
-
1Ad
NULL

How would the Oracle Database sort this by default?

How would LINQ sort this by default?

How would db2 sort this by default?

(the following may get even more vague)

How does the Windows platform sort this? (I mean say you have a couple of filenames, by default how would this get treated in a name sort)

How does the *nix platform sort this?

Is there some sort of standard for alphanumeric/special character sorting? The Windows operating system orders with numbers first, then alphabets. The Oracle database however treats alphabets first. I'm not sure of the *nix platform.

It would be nice to have one place to know all these rules for the most common platforms (listed in questions above). Would the gurus throw some light on this topic?

Cheers, K

© Stack Overflow or respective owner

Related posts about sorting

Sorting eigenvectors by their eigenvalues (associated sorting)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an unsorted vector of eigenvalues and a related matrix of eigenvectors. I'd like to sort the columns of the matrix with respect to the sorted set of eigenvalues. (e.g., if eigenvalue[3] moves to eigenvalue[2], I want column 3 of the eigenvector matrix to move over to column 2.) I know I can… >>> More
Sorting in SSRS Reports overriding Group sorting

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to SSRS (2005) and am creating my first report. I need to create a group-based running value but is sorted or some other field. For example, from the data below |Employee| Day |Hours|Salary| |E1 | 1.1 | 5 | 5 | |E2 | 1.2 | 6 | 6 | |E3 | 1.3 | 7 | 7 | |E2 … >>> More
org-sort multi: date/time (?d ?t) | priority (?p) | title (?a)

as seen on Super User - Search for 'Super User'
Is anyone aware of an org-sort function / modification that can refile / organize a group of TODO so that it sorts them by three (3) criteria: first sort by due date, second sort by priority, and third sort by by title of the task? EDIT: I believe that org-sort by deadline (?d) has a bug that… >>> More
A Look at the GridView's New Sorting Styles in ASP.NET 4.0

as seen on Internet.com - Search for 'Internet.com'
Scott Mitchell looks at four new sorting-related style properties added to the GridView in ASP.NET 4.0. >>> More
A Look at the GridView's New Sorting Styles in ASP.NET 4.0

as seen on 4 Guys From Rolla - Search for '4 Guys From Rolla'
Like every Web control in the ASP.NET toolbox, the GridView includes a variety of style-related properties, including CssClass, Font, ForeColor, BackColor, Width, Height, and so on. The GridView also includes style properties that apply to certain classes of rows in the grid, such as RowStyle,… >>> More

Related posts about alphanumeric

Exclude all normal alphanumeric character from a mixed chinese-and-alphanumeric character word list

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a list of chinese characters and normal alphanumeric characters, mixed together, and I want to get rid of any element that contains an alphanumeric character. Is there a simple way to do this? If I simply exclude any element that contains an alphanumeric character, I get no result because the… >>> More
Auto Generate alphanumeric Unique Id with C#

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, total string length is 5 chars I have a scenario, ID starts with A0001 and ends with A9999 then B0001 to B9999 until F0001 to f9999 after that FA001 to FA999 then FB001 to FB999 until ....FFFF9 Please suggest any idea on how to create this format Thanks in advance >>> More
Removing non-alphanumeric characters in an Access Field.

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to remove hyphens from a string in a large number of access fields. What's the best way to go about doing this? Currently, the entries are follow this general format: 2010-54-1 2010-56-1 etc. I'm trying to run append queries off of this field, but I'm always getting validation errors causing… >>> More
Short Python alphanumeric hash with minimal collisions

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to set non-integer primary keys for a table using some kind of hash function. md5() seems to be kind of long (32-characters). What are some alternative hash functions that perhaps use every letter in the alphabet as well as integers that are perhaps shorter in string length and have low… >>> More
Removing characters from a alphanumeric field SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Im moving data from one table to another using insert into. in the select bit need to transfer from column with characters and numerical in to another with only the numerical. The original column is in varchar format. original column - ABC100 XYZ:200 DD2000 Wanted column 100 200 2000 Cant write… >>> More