UTF sorting and blank fields, and UTF-8

[Frank Schima]

Hi guys,


On Dec 12, 2005, at 11:24 AM, Ruslan Zasukhin wrote:

> On 12/12/05 8:14 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
>
> Hi Dave,
>
>> I’m a long-time V4RB 1.9, finally making the switch to V4RB  
>> 2.0.5.  So, I
>> have a few questions :-)
>>
>> Firstly, is there a way I can get my SELECT statements to order  
>> with blank
>> fields appearing *after* all other fields?  For example, if I do  
>> "SELECT *
>> from songstable order by album", I want everything with a non- 
>> blank VarChar
>> in the 'album' table to come first in UTF sorted order, followed  
>> finally by
>> all records with blank album fields.
>
>> It seems that by default, blank fields come *first* when I sort in  
>> ascending
>> order.
>
> I see what you mean.
>
> Right now no. But you can add feature request into our Mantis.
> I believe we can easy implement this as property:
>
>     Valentina.NullsAreFirst as Boolean = true

I already made this feature request some time ago:

<http://paradigma.ukrcom.kherson.ua/bt/view.php?id=457>


Best regards,
Frank Schima

I'm currently job hunting:
<http://homepage.mac.com/macsforever2000/resume.html>