Dumping Result from direct statement ... 01. id_nbyte3 FT_BYTE4 20 02. nbyte0 FT_NBYTE0 1 03. nbyte1 FT_BYTE2 150 04. byte2 FT_BYTE2 -10 05. byte4 FT_BYTE4 -90000 06. nbyte8 FT_BYTE8 3200100 07. real9 FT_REAL9 8.72341000E+01 08. real18 FT_REAL18 1.55552137928312000E+04 09. exact_decimal FT_REAL18 8.75440000000000000E+02 10. my_date FT_TIMESTAMP 2014-10-20 00:00:00 11. my_timestamp FT_TIMESTAMP 2000-03-25 15:15:00 12. my_time FT_TIMESTAMP 1901-01-01 20:18:13 13. my_year FT_BYTE2 1986 14. my_tinytext FT_UTF8 AdaBase is so cool! 15. enumtype FT_ENUMTYPE green 16. settype FT_UTF8 yellow,black 17. my_varbinary FT_CHAIN 20 30 31 32 33 18. my_blob FT_CHAIN 34 35 36 37 38 39 41 42 43 2E 2C 7A 5B 5D 01. id_nbyte3 FT_BYTE4 25 02. nbyte0 FT_NBYTE0 0 03. nbyte1 FT_BYTE2 200 04. byte2 FT_BYTE2 25 05. byte4 FT_BYTE4 22222 06. nbyte8 FT_BYTE8 50 07. real9 FT_REAL9 4.84325000E+00 08. real18 FT_REAL18 9.23496312323599000E+06 09. exact_decimal FT_REAL18 1.57900000000000000E+01 10. my_date FT_TIMESTAMP 1910-11-05 00:00:00 11. my_timestamp FT_TIMESTAMP 2030-12-25 11:59:59 12. my_time FT_TIMESTAMP 1901-01-01 04:00:45 13. my_year FT_BYTE2 1945 14. my_tinytext FT_UTF8 This is what it sounds like when doves cry 15. enumtype FT_ENUMTYPE red 16. settype FT_UTF8 blue,white 17. my_varbinary FT_CHAIN 51 7C 45 52 18. my_blob FT_CHAIN 30 31 32 33 34 00 0A 37 38 39 Dumping Result from prepared statement ... 01. id_nbyte3 FT_BYTE4 20 02. nbyte0 FT_NBYTE0 1 03. nbyte1 FT_BYTE2 150 04. byte2 FT_BYTE2 -10 05. byte4 FT_BYTE4 -90000 06. nbyte8 FT_BYTE8 3200100 07. real9 FT_REAL9 8.72341000E+01 08. real18 FT_REAL18 1.55552137928312000E+04 09. exact_decimal FT_REAL18 8.75440000000000000E+02 10. my_date FT_TIMESTAMP 2014-10-20 00:00:00 11. my_timestamp FT_TIMESTAMP 2000-03-25 15:15:00 12. my_time FT_TIMESTAMP 1901-01-01 20:18:13 13. my_year FT_BYTE2 1986 14. my_tinytext FT_UTF8 AdaBase is so cool! 15. enumtype FT_ENUMTYPE green 16. settype FT_UTF8 yellow,black 17. my_varbinary FT_CHAIN 20 30 31 32 33 18. my_blob FT_CHAIN 34 35 36 37 38 39 41 42 43 2E 2C 7A 5B 5D 01. id_nbyte3 FT_BYTE4 25 02. nbyte0 FT_NBYTE0 0 03. nbyte1 FT_BYTE2 200 04. byte2 FT_BYTE2 25 05. byte4 FT_BYTE4 22222 06. nbyte8 FT_BYTE8 50 07. real9 FT_REAL9 4.84325000E+00 08. real18 FT_REAL18 9.23496312323599000E+06 09. exact_decimal FT_REAL18 1.57900000000000000E+01 10. my_date FT_TIMESTAMP 1910-11-05 00:00:00 11. my_timestamp FT_TIMESTAMP 2030-12-25 11:59:59 12. my_time FT_TIMESTAMP 1901-01-01 04:00:45 13. my_year FT_BYTE2 1945 14. my_tinytext FT_UTF8 This is what it sounds like when doves cry 15. enumtype FT_ENUMTYPE red 16. settype FT_UTF8 blue,white 17. my_varbinary FT_CHAIN 51 7C 45 52 18. my_blob FT_CHAIN 30 31 32 33 34 00 0A 37 38 39 Note slight differences in real9 and real18 field values due to rounding differences inherent in the different retrieval mechanisms of direct and prep stmt results.