Handling accented characters

mydsworld · Post by **mydsworld** » Thu Jan 22, 2009 1:59 pm

I am trying to insert accented characters into a DB2 table using ODBC Ent stage.The accented character records are getting rejected. Is there any way we can insert them (without using Datastage 'convert').

Thanks.

kandyshandy · Post by **kandyshandy** » Thu Jan 22, 2009 2:05 pm

You mean something like this? āk'sěnt'

mydsworld · Post by **mydsworld** » Thu Jan 22, 2009 2:47 pm

My job design is following :

Seq File -> Transformer -> ODBC Ent (with Reject link)

I have set 'UTF-8' in only ODBC Ent stage. The error due to the accented char is shown below :

Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the [odbcUtils.C:1289]

Records with accented char go to Reject link due to the above.When I convert those accented char into English, data gets loaded.

Please advise what NLS option I have to use and in which stage.

mydsworld · Post by **mydsworld** » Thu Jan 22, 2009 4:09 pm

Has anyone encountered this problem earlier and can advise me.

Thanks.

jdmiceli · Post by **jdmiceli** » Thu Jan 22, 2009 4:26 pm

I have an issue where my source databases can have all kinds of high ASCII characters (general from cut and paste operations) and since I use a src --> text file --> target, I end up with all kinds of problems. I borrowed a routine from some of the great minds here and then modified it to interpret certain high ASCII chars to standard ASCII(32-127). This may not be what you want, but it is pretty efficient and stops all kinds of problems on the processing end. If you would like to see the routine, I'll be happy to post it. Just let me know.

mydsworld · Post by **mydsworld** » Thu Jan 22, 2009 4:40 pm

Actually I dont want to convert these accented characters into something else and load, rather would like to load them as is.
Thanks for your response.