Insert a double exclamation point "!!" into a table's varchar field

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tomo
Posts: 1
Joined: Mon 15 Feb 2021 14:28

Insert a double exclamation point "!!" into a table's varchar field

Post by tomo » Mon 15 Feb 2021 14:39

I'm using C++Builder 10.4.1 and I want to insert a string , which includes two exclamation points in a row (i.e.: "!!abc!!"). If I use ADOconection and ADOquery, the field in a table is filled as it should be: "!!abc!!". But, if I use FireDAC (FDConnection and FDQuery), the field is filled with "!abc!". Where's the catch and which setings should I change to make it work properly ?

Thanks.

Tomaz

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: Insert a double exclamation point "!!" into a table's varchar field

Post by Stellar » Tue 16 Feb 2021 10:35

FireDAC components (FDConnection, FDQuery, TFDTable, etc) are developed by Embarcadero. Please contact their technical support for assistance or search for relevant topics on specialized forums. We're always ready to answer any questions about our components.

Post Reply