Subject | two machines - different resultsets for ORDER BY |
---|---|
Author | d_dude_2003 |
Post date | 2006-05-22T08:00:13Z |
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?
Any FireBird settings in config files?
Thanks.
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?
Any FireBird settings in config files?
Thanks.