search

qwerin / fusion-tables

Automatically exported from code.google.com/p/fusion-tables
0 stars 1 forks source link

Case insensitive sorting via ORDER BY clause #1334

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Would be great to add an option for case insensitive sorting while selecting 
from fusion table using ORDER BY column_name clause.

Something like we have in "general" SQL - ORDER BY LOWER(field) or ORDER BY 
field COLLATE NOCASE.

For the moment if you have a records with field with, for example, family 
names: 

ABRAHAMS Abrahams SMITH Smith 

and make a "SELECT ... ORDER BY family_name" you will get not you probably 
expected:

ABRAHAMS
SMITH
Abrahams
Smith

With case insensitive sorting I would like to get:

ABRAHAMS
Abrahams
Smith
Smith

Thanks in advance and Happy New Year!

Alexandr

Original issue reported on code.google.com by alexandr...@gmail.com on 29 Dec 2013 at 7:43

GoogleCodeExporter commented 9 years ago 
This would be a nice thing to have, no doubt.

Original comment by rmcch...@google.com on 16 Jan 2014 at 2:21

GoogleCodeExporter commented 9 years ago 
Is this available now? If not, is there a workaround?

Original comment by vxbha...@gmail.com on 23 Aug 2014 at 1:19