How to insert a string with quotes into a char datatype?

Database
Enthusiast

How to insert a string with quotes into a char datatype?

Hi,

I have a table with the following definition:

CREATE SET TABLE db_name.tbl_a ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
col1 CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( col1 );

Now i am trying to insert the following : ab'cd

how do i insert the above string into the table using:
insert into tbl_a values....

2 REPLIES
Enthusiast

Re: How to insert a string with quotes into a char datatype?


e.g
insert into tbl_a values('ab''cd');

Two consequent ' stand for one ' in teradata.
Enthusiast

Re: How to insert a string with quotes into a char datatype?

Thank you