Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Florian Klämpfl via fpc-pascal
> Am 10.03.2021 um 04:59 schrieb Toru Takubo via fpc-pascal > : > >> Can you please post the output of -va of the arm compiler and provide some >> information about the arm system you are using? > > The output message with -va option can be downloaded from below. > >

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread LacaK via fpc-pascal
Dňa 9.3.2021 o 15:34 Toru Takubo via fpc-pascal napísal(a): On 2021/03/09 18:11, LacaK via fpc-pascal wrote: I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Thank you for your reproduction test. It may be a good news that the problem would

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/10 5:40, Florian Klämpfl via fpc-pascal wrote: Am 09.03.21 um 01:47 schrieb Toru Takubo via fpc-pascal: On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am developing my app on Windows and building apps

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Florian Klämpfl via fpc-pascal wrote: By using the necessary IFDEF mechanism in the config file, we can avoid inserting it for windows (which does not need it) or the smaller embedded platforms (which cannot handle it). People that don't need/want this can remove the

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Florian Klämpfl via fpc-pascal
Am 09.03.21 um 01:47 schrieb Toru Takubo via fpc-pascal: On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am developing my app on Windows and building apps for other platforms by using cross compiler. Now I have a

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Florian Klämpfl via fpc-pascal
> Am 09.03.2021 um 10:06 schrieb Michael Van Canneyt via fpc-pascal > : > >  > >> On Tue, 9 Mar 2021, Graeme Geldenhuys via fpc-pascal wrote: >> >>> On 09/03/2021 1:44 am, Tomas Hajny via fpc-pascal wrote: >>> UnicodeString may be used in a program simply because the included unit has >>>

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/09 18:11, LacaK via fpc-pascal wrote: I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Thank you for your reproduction test. It may be a good news that the problem would not be in the compiler but around configuration or environment.

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Tomas Hajny via fpc-pascal
On 2021-03-09 09:46, Graeme Geldenhuys via fpc-pascal wrote: On 09/03/2021 1:44 am, Tomas Hajny via fpc-pascal wrote: UnicodeString may be used in a program simply because the included unit has it used in its interface. That may be the case even if there's no use of characters outside of US

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread LacaK via fpc-pascal
I did run test program on RaspberryPI: Linux+ARM and results are as expected. (FPC 3.2.0) -Laco. Dňa 9.3.2021 o 1:47 Toru Takubo via fpc-pascal napísal(a): On 2021/03/08 16:54, Michael Van Canneyt via fpc-pascal wrote: On Mon, 8 Mar 2021, Toru Takubo via fpc-pascal wrote: Hi, I am

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Mattias Gaertner via fpc-pascal wrote: On Tue, 9 Mar 2021 08:04:54 +0100 Sven Barth via fpc-pascal wrote: [...] FPC is not Java. In FPC you have more fine-grained control over the resulting binary than "install big, fat runtime". Not to mention that FPC can target

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: thank you for the test program. I tested on linux 64-bit, that works OK too. When you look in the database on the arm machine  with an sqlite tool, do you see the correct values or are the inserted values wrong ? (I'm trying to

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Graeme Geldenhuys via fpc-pascal wrote: On 09/03/2021 1:44 am, Tomas Hajny via fpc-pascal wrote: UnicodeString may be used in a program simply because the included unit has it used in its interface. That may be the case even if there's no use of characters outside of US

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Mattias Gaertner via fpc-pascal
On Tue, 9 Mar 2021 08:04:54 +0100 Sven Barth via fpc-pascal wrote: >[...] > FPC is not Java. In FPC you have more fine-grained control over the > resulting binary than "install big, fat runtime". Not to mention that > FPC can target resource constrained systems as well. Optional is good. Maybe

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Toru Takubo via fpc-pascal
On 2021/03/09 17:07, Michael Van Canneyt via fpc-pascal wrote: On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: I don't know what to advise to further investigate the issue, One thing to try would be to test whether normal float arithmetic or date arithmetic works. If not, then the

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Gabriele Cappelletto via fpc-pascal
It happened to me with Firebird too. Only that the error gave it to me in reading, that is db.fieldByName ('cc'). AsDateTime Il 08/03/21 02:31, Toru Takubo via fpc-pascal ha scritto: Hi, I am developing my app on Windows and building apps for other platforms by using cross compiler. Now I

Re: [fpc-pascal] Unicode chars losing information

2021-03-09 Thread Graeme Geldenhuys via fpc-pascal
On 09/03/2021 1:44 am, Tomas Hajny via fpc-pascal wrote: > UnicodeString may be used in a program simply because the included unit > has it used in its interface. That may be the case even if there's no > use of characters outside of US ASCII at all. So FPC rather goes with the fact that data

Re: [fpc-pascal] Cannot write datetime field on sqlite3 database on ARM

2021-03-09 Thread Michael Van Canneyt via fpc-pascal
On Tue, 9 Mar 2021, Toru Takubo via fpc-pascal wrote: I don't know what to advise to further investigate the issue, One thing to try would be to test whether normal float arithmetic or date arithmetic works. If not, then the compiler people will need to give more advice. I created a