But if i use UNICODE_FSS ? any other way ?

Thanks,
Diko


-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Monday, June 17, 2002 10:18 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Sorting


Hi,

Take a look at charactersets and collations for case insensitive sorts.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hai All,
>
> How i can sorting this data in table :
>
> 1 admin
> 2 ADMIN
> 3 baby
> 4 BABY
>
> where :
>
> 2 ADMIN
> 1 admin
> 4 BABY
> 3 baby
>
> ???
>
> I have used ORDER BY, but the result :
>
> 2 ADMIN
> 4 BABY
> 1 admin
> 3 baby

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/