summaryrefslogtreecommitdiffstats
path: root/src/interfaces/ecpg/test/preproc/strings.pgc
blob: 2968d5464ae3b10c5e6a40158031cc6f07748da5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#include <../regression.h>

exec sql begin declare section;
#include <strings.h>
exec sql end declare section;

int main(void)
{
  ECPGdebug(1, stderr);

  exec sql connect to REGRESSDB1;

  exec sql set standard_conforming_strings to on;

  exec sql select 'abcdef',
                  N'abcdef' AS foo,
                  E'abc\bdef' AS "foo",
                  U&'d\0061t\0061' AS U&"foo",
                  U&'d!+000061t!+000061' uescape '!',
                  $foo$abc$def$foo$
                  into :s1, :s2, :s3, :s4, :s5, :s6;

  printf("%s %s %s %s %s %s\n", s1, s2, s3, s4, s5, s6);

  exec sql select b'0010', X'019ABcd'
                  into :s7, :s8;

  printf("%s %s\n", s7, s8);

  exec sql disconnect;
  return 0;
}