Striim

Welcome to the Striim Help Center and Community Site

3.10.3 Using special characters in table identifiers

Follow

Striim supports special characters in Tables property values for Oracle and SQL Server sources (Database Reader, MSSQL Reader, and Oracle Reader) and targets (Database Writer) as follows:

  • Identifiers containing special characters must be enclosed in double quotes: for example, MySchema."My@Table"

  • Each identifier containing special characters in multi-part table names must be escaped separately: for example, "My@Schema"."My@Table"

  • Special characters are not supported in column names.

  • When replicating data, if the source and target Tables properties use the % wildcard, special characters are preserved, provided the WAEvent output of the source is not parsed (see Parsing the data field of WAEvent) before reaching the target. If the output of the source is parsed, special characters will be lost unless stored in a field as strings. For example:

    CREATE TYPE ParsedDataType(
      TableName String,
      ...
    );
    CREATE STREAM OracleTypedStream OF ParsedDataType;
    CREATE CQ ParseOracleCDCStream
      INSERT INTO OracleParsedStream
      SELECT META(x, "TableName").toString(),
      ...
      FROM OracleCDCStream x;
  • The following special characters are supported:

character

name

UTF-8

#

number sign

0023

$

dollar sign

0024

&

ampersand

0026

(

left parenthesis

0028

)

right parenthesis

0029

*

asterisk

002A

+

plus sign

002B

,

comma

002C

-

hyphen

002D

:

colon

003A

!

exclamation point

003A

;

semicolon

003B

<

less than sign

003C

=

equals sign

003D

>

greater than sign

003E

?

question mark

003F

@

at sign

0400

[

left square bracket

005B

]

right square bracket

005D

^

caret

005E

_

underscore

005F

`

grave accent (backtick)

0060

{

left curly bracket

007B

|

vertical line (pipe)

007C

}

right curly bracket

007D

~

tilde

007E

3.10.3
Was this article helpful?
0 out of 0 found this helpful

Comments