Is Firedac stripping out exclamation marks?


Hi, I'm trying to insert some data into a mysql table using an fdquery object in Delphi 10, which works fine except it does not insert all the exclamation marks (!) present into the varchar fields


"Hello!/Goodbye!" will be inserted as "Hello/Goodbye"


Hello! Goodbye! will be inserted as "Hello! Goodbye"

I created a test table for the example above consisiting of a single varchar field of length 100.

The statement I used was:

Insert into test values ('Hello!/Goodbye!'), ('Hello! Goodbye!');

I've run the exact same query through toad using the same connection parameters and that works perfectly, all exclamation marks are present.

Any ideas what may be causing this and how I can get around it.



Responses (0)
  • There are no replies here yet.
Your Reply

Please login to post a reply.........