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.
Meh.
Written by Will Madison
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Teradata
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#