Archives of the TeradataForum

Message Posted: Fri, 09 Nov 2012 @ 11:23:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

To compress a single quote, you use 2. These 2 need to be encapsulated in quotes, so you end up with 4. Please see below.

     create table test
     (col1 char(1)
     , col2 char(10) compress '''')

Regards

Frank

	<Prev	Next>		<<First	<Prev	Next>	Last>>