Archives of the TeradataForum

Message Posted: Tue, 04 Nov 2003 @ 19:42:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I'd like to hear from those of you who have to store occasional text information with non-Latin characters like Cyrillic, Greek or Hebrew. I guess the systematic way to do it would be to use Unicode in the column definition but Unicode is expensive in terms of storage.

If non-Latin data forms only a small part of the data in the table is there any chance to store it using some 8- or perhaps 7-bit encodings? By this I mean that I don't want to use any non-Latin string literals in my queries and would be happy to only get the data in queries like this:

select text_info
from my_table
where language = 'HEBREW'.

The interpretation of the characters would be done by the client with the use of the appropriate fonts etc. I would appeciate to hear about best practices in this area.

Thanks,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>