Joinutility seperatorLogin utility separator Infobright.com
   
 
The problem with data sorting is case insensitive.
 
Gleb
Posted: 15 February 2010 12:13 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  3
Joined  2010-02-15

Hi all.

I have a table contains entries with different character case.
Query form:

SELECT id, name FROM mytable ORDER BY name 

not work correctly.
First, a string starting with an uppercase letter, after them - lines starting with a lowercase letter.
For example:
Ajax
ZEND
ajax2
zend2

How can I solve this problem?
Thank you in advance.

Profile
 
Kim Christensen
Posted: 15 February 2010 03:52 AM   [ Ignore ]   [ # 1 ]  
Newbie
Rank
Total Posts:  15
Joined  2009-06-19

The sorting in Infobright are case sensitive.
To sort without regard to case sensitivity you can do something like this.

SELECT id, name FROM mytable ORDER BY LOWER(name) 

This produces the same output as the default MySQL behaviour.

Signature 
Profile
 
Gleb
Posted: 15 February 2010 05:32 AM   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  3
Joined  2010-02-15

Thank you. It helped me a lot.

Profile
 
Janusz Borkowski
Posted: 15 February 2010 06:16 AM   [ Ignore ]   [ # 3 ]  
Super Duper Member
Avatar
RankRankRankRankRank
Total Posts:  916
Joined  2008-08-18

Hi !

You can also wait for the upcoming release with UTF8 support. In addition to UTF8 various collations will be supported, including case insensitive.

Profile
 
Gleb
Posted: 15 February 2010 06:24 AM   [ Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  3
Joined  2010-02-15

Thank you.
The problem is solved completely.

Profile
 
   
 
 
‹‹ UTF8 support implemented in ICE 3.3.1?      Rename table support ››