Archives of the TeradataForum

Message Posted: Mon, 22 May 2006 @ 14:18:52 GMT


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

Subj:		Re: UMLAUT Characters

From:		Victor Sokovin

Try reading up on the Translate_Chk function:

Assuming the Umlaut Character isn't Latin (I'm not certain about that), then this should get flagged if you try to convert using 'Unicode_to_Latin'.

Umlauts are actually included in the TD Latin repertoire so this conversion won't help.

I'm afraid the OP faces a rather painful char-by-char translation here (painful not because of the umlauts as such but because char translation is difficult in TD in general) or has to do the conversion outside of the database.

Alternatively, the OP could check with the users what exactly is causing the problem. A request to get rid of umlauts sounds a bit ad hoc and strange.

Regards,

Victor