tpump, fastexport, insert into ... - problem with charset

Tools & Utilities
Enthusiast

tpump, fastexport, insert into ... - problem with charset

Hi all

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

kostek

1 REPLY
Enthusiast

Re: tpump, fastexport, insert into ... - problem with charset

Hi

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

cheers