Subject Re: [firebird-support] two machines - different resultsets for ORDER BY
Author Dimitry Sibiryakov
On 22 May 2006 at 8:00, d_dude_2003 wrote:

>I have a stored procedure which returns the rows
>using ORDER BY StringField ASC, IDField DESC...
>
>On my machine, it works as expected. However on customer's machine
>StringFields are slighly out of order. For example, it first returns
>Bxxxxxx, then few Cxxx rows, then again Bxxxxx...
>
>What could cause this? Does Regional Settings affects this?

Nope. It may be broken index (if one is used) or different
data/metadata.

--
SY, Dimitry Sibiryakov.