0

We are migrating our back-end database from Oracle to MySQL. The front-end application is built on Access. The problem is that Oracle and MySQL handle nulls differently, which changes the order in which they are displayed in the front-end application: in Oracle, nulls are considered maximum values, but in MySQL, nulls are considered minimum values. I can change the order in which nulls are displayed by changing the query in the front-end application, but I would like to reduce the amount of change if possible, so I would like to be able to configure MySQL on the back-end to consider nulls as maximum values. Any ideas?

Tsubasa Otsu
  • 1
  • 2
  • Does this answer your question? [SQL how to make null values come last when sorting ascending](https://stackoverflow.com/questions/1498648/sql-how-to-make-null-values-come-last-when-sorting-ascending) – Ken Y-N Dec 02 '22 at 07:33
  • MySQL have no NULLS FIRST/LAST sorting option or system option. You'd use `ORDER BY column IS [NOT] NULL, {other sorting expressions}`. – Akina Dec 02 '22 at 07:40
  • @KenY-N Thank you for your suggestion, but it seems that we need to change the query used in Access. I would like to avoid it. – Tsubasa Otsu Dec 02 '22 at 08:59
  • @Akina Thank you for your advice. Although I have read some references and there seems to be no option, someone may know the option, so I posted this question. Anyway it is glad to know there's completely no option to change null treatment. – Tsubasa Otsu Dec 02 '22 at 09:03

0 Answers0