SUPPORT / SAMPLES & SAS NOTES
Problem Note 15793: MODE=Teradata does not allow Teradata case insensitive behavior when comparing character strings in the WHERE clause
 |  |  |  |  |
When you set MODE=Teradata where only the T in Teradata is capitalized, the default mode of ansi is still in effect. With this setting, when you subset your data based on a text field, the character comparison will be case sensitive. However, if you set MODE=teradata(teradata in all lowercase letters) or MODE=TERADATA(TERADATA in all uppercase), the character comparison will be case-insensitive.
Currently, the only workaround is to specify Teradata in lowercase(teradata) or uppercase(TERADATA).
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP4 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP4 | ||