Subject: | Postgresql Character escaping
| Date: | Tue, 5 May 2020 16:10:44 -0500
| From: | Mark Bannister <markRemove@THISinjection-moldings.com>
| Newsgroups: | pnews.paradox-client_server
|
Trying to find the best method of escaping text properly for inserting
into a table. I thought I could use dollar quoting $$mystring$$ but the
bde is for some reason trying to parse remote queries and chokes if
there are single or double quotes in the text.
so this fails because of the single quote '
INSERT INTO __test_table
(text_test)
VALUES($$fr"ed2$$ );
The only thing that I found that appears to be working is using the
escape "e" pg style and doubling all ' " \ when they appear
INSERT INTO __test_table
(text_test)
VALUES(E'fr""ed2' );
works with value = 'fr"ed'
--
Mark B
|