How to store and display a german umlaut?

Database
Enthusiast

How to store and display a german umlaut?

I thought Dieter might be able to jump in on this one since his last name is really Doter with an umlaut over the o.

We are in the process of pulling data out of SAP ECC into a Teradata 13.10 database.  I have defined one of the tables as follows:

CREATE SET TABLE DEV_SAP_POC.COUNTRY_TEXT ,NO FALLBACK ,

NO BEFORE JOURNAL,

NO AFTER JOURNAL,

CHECKSUM = DEFAULT

(

SPRAS VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,

LAND1 VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,

TXTSH VARCHAR(20) CHARACTER SET UNICODE NOT CASESPECIFIC,

ODQ_CHANGEMODE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,

ODQ_ENTITYCNTR DECIMAL(19,0))

PRIMARY INDEX ( SPRAS );

Note the third field is defined as UNICODE.  I have also updated my ODBC driver to UTF16.  When selecting from the table I am unable to display the umlaut over the A:

     D ZA Südafrika  N 0

Generically speaking, what is the best way to store and access a special character umlaut? 

Thanks in advance,

Joe

Tags (1)
4 REPLIES
Enthusiast

Re: How to store and display a german umlaut?

Sorry Dieter... I hammered your last name... I meant Noth with an umlaut over the o.

Teradata Employee

Re: How to store and display a german umlaut?

Hi,

UNICODE should fix the issue. I am using following and i can see it properly when selecting:

CREATE SET VOLATILE TABLE Table1 ,NO FALLBACK ,

     CHECKSUM = DEFAULT,

     LOG

     (

      col1 VARCHAR(10) CHARACTER SET UNICODE NOT CASESPECIFIC)

PRIMARY INDEX ( col1 )

ON COMMIT PRESERVE ROWS;

INSERT table1 VALUES ('Ã');

SELECT * FROM Table1;

col1

1 Ã

My session character set is ASCII.

Regards, Adeel

Junior Contributor

Re: How to store and display a german umlaut?

Hi Joe,

you probably just have a display problem, what tool are you using?

In SQL Assistant you need to set a font which actually includes Unicode characters, e.g. "Lucida Sans Unicode".

Btw, to store german Umlauts you don't need Unicode, they're also in the Latin charset.

Dieter

Enthusiast

Re: How to store and display a german umlaut?

Thanks Dieter!

The problem was actually a setting within Data Services.  Once the setting was changed to utf16, I believe it fixed the problem.  Thank you all very much for your responses!

btw... I was using SQL Assistant so it is good to know about the new font setting.

Joe