Last Updated: February 25, 2016
· wmadisondev

Teradata ETL Fail

Ran into this BEAUTIFUL jewel of an "easter egg" in Teradata's documentation:

"The LOWER function operates with the LATIN server character set. If the type of argument for LOWER is anything other than LATIN, LOWER attempts to translate the non-LATIN string to LATIN before evaluation.

If the string cannot be converted successfully, an error is returned.

Note that a constant string is an acceptable argument because it is implicitly converted from UNICODE to LATIN before it is evaluated."

I guess it didn't occur to the great folks over at TD that maybe, just maybe not every character available in popular encodings like UTF-8 can be represented in Latin-1.