Re: [sqlite] ORDER BY clause with column values not case-sensitive

[Srikanth]

Dennis,
It works. Thanks a lot.
Srikanth.

On 6/27/06, Dennis Cote <[EMAIL PROTECTED]> wrote:

Srikanth wrote:
> Is there a way to order the results of a select statement using the
> values of a column name, with the values in that column insensitive?
> E.g., If the column has the following values: Zambia, italy,Iceland,
> then a regular "ORDER BY tablename.country DESC" would result in:
>
> italy
> Zambia
> Iceland
>
> I want my output to be:
> Zambia
> italy
> Iceland.
>
Srikanth,

Add COLLATE NOCASE to the column definition of the country column in
your table.

CREATE TABLE name (
    ...
    country    text collate nocase,
    ...
);

HTH
Dennis Cote