Issue with CurrentDate and CurrentTime System variables
December 4, 2016 12:00 AM
Hello. I live in Thailand and doing some research using Lectora to deliver testing and teaching materials. One of the things I am doing is to track which buttons the participants press. I create a string which contains the date and/or time of the button press (or whatever) and the string is then sent to a mysql database through the submission of a Lectora form (quite fast and good etc.).
My problem is that living in Thailand means that all the computers are running Thai Windows. Students can switch between character sets (English/Thai) depending on what they are doing. When I run my Lectora titles, sometimes (not always) the date (or time) is stored correctly and sometimes not. When it is stored incorrectly, the problem looks as follows:
Instead of saying "11/27/2016: ENTER: Unit01LR" it says "‎11‎/‎27‎/‎2016: ENTER: Unit01LR"
You can see that the 11, 27 and 2016 are embedded in the string but messed up.
I do not think that this is a problem with mysql collation or anything to do with the server, but with the PC on which the program is run. It feels like it depends on how the local PC's language/local settings have been set up.
Is there perhaps some way of forcing the date to be written in standard English rather than something else - or are CurrentDate/CurrentTime always dependent on the computer's default settings?
It seems like a longshot but I thought I would ask anyway.
Thank you
Andrew
undefined
Discussion (1)
If you haven't already I would recommend submitting this content as a Support ticket.
Discussions have been disabled for this post