On 2020-02-26 19:41, hamacker [email protected] [firebird-support] wrote: > When I started my test, I turn off my app. > > And do update(and select) using only ISQL tool (IBExpert) and > dbweaver. > in both I had to configure select to show float using mask > (0.######..), so the number can be different that I show you, but > always eat last numbers.I need to store long decimals numbers maybe > more than 15 decimals, is it possible without store as string?
Firebird 3 supports a maximum precision of 18 using the fixed point types `NUMERIC(18,x)` and `DECIMAL(18,x)`, however then you most now the number decimals at declaration time. If you need floating-point-like behaviour, you need to wait for Firebird 4, where you can use datatype DECFLOAT (precision of 34), or maybe the extended precision DECIMAL/NUMERIC with a maximum precision of 38. Storing as string is an option, but that will make it very hard to do any calculation with them, and might force you to cast to `double precision` to perform that calculation, which throws any benefit of the stored precision out of the door. Mark
