Paradox Community

Items in pnews.paradox-client_server

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


Copyright © 2004 thedbcommunity.com