Archives of the TeradataForum

Message Posted: Mon, 27 Nov 2006 @ 18:26:43 GMT

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

You cast an output record to CHAR(400) in Unicode under the UTF8 session character set.

So, DBS uses a 3xN formula as the Export Width for a CHAR(N) column.

Therefore, you are getting 1200 bytes per record.

The Export Width is a system-wide option and I don't recommend to change the default.

Instead, your application that will read the exported data should expect the record length based on the Export Width.

The Export Width will only apply for CHAR columns, but not VARCHAR.

For the Export Width, please refer to the Internationalization orange book or the International Character Set Support manual for more details.

TT

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