Archives of the TeradataForum
Message Posted: Mon, 24 Jun 2002 @ 12:29:56 GMT
| 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
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.