So the offensing characters are a "schwa" followed byan apostrophe. When I use c# replace method to remove apostrophes it was removing all postrophes except this one tick character
that chaacter was precedby the schwa
I copied that tick mark to use in the c# replace function and that works fine. However, the schwa is being entered into the teradat dabates as a quesion mark. Can anyone help me out?
Neither of those characters are in the Teradata Latin repertoire, but both are included in the Teradata Unicode repertoire.
So you would need to define the target column as Unicode to store the values. And you will need to use a session character set other than "ASCII", e.g. UTF8 or UTF16, both for loading and for querying.
So there's a Unicode data type in teradata that I should be setting it to? And how would I use a session character other than ASCII?
In the column definition for CHAR(n) or VARCHAR(n) you can append CHARACTER SET UNICODE.
The way you specify the session (or "client") character set depends on the client you are using.
For "legacy" Teradata utilities, it's a run-time option, and for TPT it's in the script. For ODBC DSNs, there's a drop-down in the configuration dialog on Windows; on Unix/Linux/MacOS use the CharacterSet keyword in the data source specifcation in the odbc.ini file. For JDBC use the CHARSET property for the connection.
HI and thanks for the reply. Where would I make the client change if I"m using the Teada.NET driver and connecting . NET code?
For the .NET provider, it would be the SessionCharacterSet attribute in the ConnectionString.