|Subject||Re: [firebird-support] two machines - different resultsets for ORDER BY|
>I have a stored procedure which returns the rowsPerhaps leading spaces in data ?
> 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?No.
> Any FireBird settings in config files?DoNotSortCsBetweenBs=True