UTF Conversion error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

UTF Conversion error

Post by mydsworld »

I have source column with 'varchar'.From source data is coming to Transformer where I have used StringToUstring(<data.column>,'UTF-16') and in target (FTP Plug-in)I have column defined as 'varchar' with extended property 'Unicode' set.In target I have set NLS map 'UTF-16'. I am getting error like this :

U_TRUNCATED_CHAR_FOUND encountered.
Encoding conversion error : Truncated character found
Warning: ??????????????????

However I am able to do conversion for UTF-8.
Please advise.
gbusson
Participant
Posts: 98
Joined: Fri Oct 07, 2005 2:50 am
Location: France
Contact:

Post by gbusson »

Note that with UTF-16, varchar [16] is 32 bytes long!

be careful with the sizes of your strings.
Post Reply