I've got a problem with character encoding(polish letters in this case).
I've two tables, both have varchar columns character set unicode , let say A and B. Process looks liake that:
1. Table A is loaded from file using tpump
2. Table B is loaded just by using insert into... .
3. Export(join table A and B) using fastexport
Everything is run on UNIX
Now when I run select * in sql assistant(connect with charset utf8) strings from table A are not displayed properly(some special characters instead of polish letters) but strings from table B looks good.
In the output file from fastexport strings from table A looks OK whilst from table B contains some special characters instead of polish letters.
My question is what I need to do to have proper polish letters in every stage of process - that means in table A, B and in output file after export?
I've try tpump and fast export with -c utf8 option but had an error like UTY8713 RDBMS failure, 6705: An illegally formed character string...
Thanks in advance
Ok, I solved this
1. I had to Convert text file to UTF8 using unix iconv command
2. Changed default character set for my teradata user from LATIN to UNICODE
3. Used tpump and fastexport with -c utf8
Now works perfect