Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Jun 2002 @ 12:29:56 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Using special characters!
From:   Geoffrey Rommel

  Does any one know how can I do to use special characteres(with sense in Spanish) in the database like '=E1' (vowel with acute-acent, or [alt]-160) or '=F1' (n with tilde or [alt]-164) . I'm working in unix with teratada v2R4.  

�Si! First, consult the Unicode table for the range x'0080' - x'00ff' : C1 Controls and Latin-1 Supplement. This can be found at


This will give you the hex values for the characters you want. You then code them in your SQL as '??'xc. For instance, 'Mar�a' would be 'Mar' || 'ED'xc || 'a' (or '4D6172ED61'xc).

If you wish to use anything above U+00FF -- Greek characters, for instance -- you will have to define your column as "character set Unicode" rather than "character set Latin" and give each character two bytes (4 hex digits). For instance, the first word of the Iliad ("Menin") in Unicode would be '039c1fc603bd03b903bd'xc.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023