|
|
Re: Numbers are returned reversed on query (Hebrew.. ) [message #688101 is a reply to message #688099] |
Thu, 17 August 2023 14:39 |
|
mathguy
Messages: 108 Registered: January 2023
|
Senior Member |
|
|
The easiest guess is that the data itself is incorrect - the number 32 was stored (instead of 23) by accident.
You seem to assume this is not the case. But, how would you know? If you select from the table, you see 32. How else (other than selecting from the table) would you know that the data in the table is correct, and only "selecting" it somehow changes it?
Are you able to replicate this - INSERT repeatedly with the number 23, then SELECT and see that it is shown as 32? Did you try something like that?
What Michel suggested will help figure this out; DUMP shows exactly what is stored in the database, byte by byte, and in order. For a question like this, using DUMP should always the first thing to try.
|
|
|