Bug 289293 - Allow Assigning/Creating Collating Sequences for Columns in SQLite
Summary: Allow Assigning/Creating Collating Sequences for Columns in SQLite
Status: CONFIRMED
Alias: None
Product: KDb
Classification: Frameworks and Libraries
Component: Driver: SQLite (show other bugs)
Version: 3.0.0
Platform: Compiled Sources Linux
: LO wishlist
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on: 278411
Blocks:
  Show dependency tree / graph
 
Reported: 2011-12-18 17:16 UTC by Jarosław Staniek
Modified: 2016-11-01 21:47 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Jarosław Staniek 2011-12-18 17:16:15 UTC 
+++ This bug was initially created as a clone of Bug #278411 +++

Version:           3.0.x (Calligra 3.0.x) (using KDE 4.6.0) 
OS:                Linux

Currently there is no way to control how the columns are sorted. Every column collation is defaulted to BINARY. This gives unexpected results when eg. sorting accented vowels.

Reproducible: Didn't try



Expected Results:  
User should be able to assign different Collating sequence for each column as it is supported by SQLite, to control the way columns are sorted.

Maybe later on support Creating Collation Sequences as per: http://www.sqlite.org/c3ref/create_collation.html