Archives of the TeradataForum

Message Posted: Thu, 25 Jul 2013 @ 15:27:20 GMT


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

Subj:		Re: Untranslable character issue

From:		Dieter Noeth

Anomy.Anom wrote:

I'm unable to insert a row from one table to its backup table. Only difference being original table has one column as LATIN and backup table has same column as UNICODE.

There's the substitute character ('1A'xc = ctrl-z) within that column, you need to replace it using TRANSLATE(col USING LATIN_TO_UNICODE WITH ERROR)

Dieter


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2013 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023