Subject | Re: [firebird-support] two machines - different resultsets for ORDER BY |
---|---|
Author | Ivan Prenosil |
Post date | 2006-05-22T08:40:02Z |
>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
Ivan