Special chars and substring
513038Oct 3 2008 — edited Oct 3 2008I have to do a substring of an input record and truncate it to 50 length and insert that record into a table.
Sometimes there are special characters in the data file the substring in bpel works fine but when trying to insert we get insert value too large for column. BPEL is considering each special char as length=1 but in database its 4 length
How do I resolve this. I want to do a substring on the ascii length instead of whatever it is.