Archives of the TeradataForum

Message Posted: Mon, 09 May 2005 @ 17:58:25 GMT

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

<-- Anonymously Posted: Monday, May 09, 2005 13:58 -->

I think you have the opposite problem: The "permanent" EBCDIC characterset is not mapping the accented characters to the appropriate Teradata internal representation. It appears to work properly when you query from the same client as the one from which the data was loaded, but only because the mapping is "invertible".

Perhaps activating and using the supplied EBCDIC037_0E characterset instead would solve this problem. But note that since the problem was introduced during the load, you may have to export the existing data using the current mapping and then reload it using the new mapping...

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