Originally posted by: WaldemarHaszlakiewicz

Hi

For whole week now I'm trying to insert an UTF-8 character to database and WTX just doesn't want to cooperate.

What is the problem?

Well I have a localized UTF-8 character (ex. 'č' -> X'C48DC' in UTF-8) and if I try to insert that to database it just get garbled and Database doesn't want to take this as a value.

Now one way around would be to just use:
insert into aplhaw.uni VALUES( X'C48D' );

But again I can't figure it out how to force WTX not to do:
insert into aplhaw.uni VALUES( "X'C48D'" ); i.e. using the whole value as text.

I've tried all sort of stuff but can't get to insert hex into this field.

Does somebody know how to write a manual PUT command that would execute the
insert into aplhaw.uni VALUES( X'C48D' ); command?

Any help would really be apprechiated as I'm becoming desperate.

Best regards
Waldemar
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

OK, keep in mind that I'm talking out of the side of my mouth here....how is your database defined? ours is native UTF8. How is the column defined? Did you genereate the tree manually or did you use DBID to generate the tree?

If you used DBID to generate the output tree, the element in the type tree should be defined exactly as the column in your table. You shouldn't have to perform a hex conversion. The transformation should occur when you drop your output into the rule cell; ie.... column:out = field:in1

If you are trying to store a hex character in a text field... you are probably going to run into a few issues and should talk to your DBA.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: WaldemarHaszlakiewicz

I've found that UTF-16LE is kinda working, but we have other issues with zOs unicode conversion service.

Now if there is no way to tell WTX to construct the insert sentence with x'...' format it doesn't matter anyway... we have ditched UTF-8 support for now.

Thanks for answering.

Br
Waldemar
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

For lack of a better way of saying it, there are different sets of UTF-8 characters. Some include latin characters some don't. The link below contains code set information. If you don't install your DB with the right UTF-8 code set you will not be able to insert the characters you desire. When you try to map a character not defined in an environment the environment will convert it to whatever it believes is close to what you are asking for. This is true for UTF-8 to ASCII flat files as well.

http://www.utf8-chartable.de/

I recommend you talk to your DBA.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: jvanboga

PS: I believe 'basic latin' code block 1024 has what you are looking for.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender