Bug 289293

Summary: Allow Assigning/Creating Collating Sequences for Columns in SQLite
Product: [Frameworks and Libraries] KDb Reporter: Jarosław Staniek <staniek>
Component: Driver: SQLiteAssignee: Jarosław Staniek <staniek>
Status: CONFIRMED ---    
Severity: wishlist    
Priority: LO    
Version: 3.0.0   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed In:
Bug Depends on: 278411    
Bug Blocks:    

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