Page 1 of 1
Posted: Wed Jun 19, 2013 12:19 pm
by chulett
Are you certain your target field is 4 characters? I'll wager it's actually 4 bytes.
Posted: Wed Jun 19, 2013 1:57 pm
by chulett
What you posted doesn't answer the question. I don't know DB2 syntax but Oracle supports both byte and character 'semantics' so saying VARCHAR(25) isn't the whole story. It can mean either 25 characters or 25 bytes depending on the semantics setting. Perhaps something similar is happening in DB2. I'd suggest you double-check with your DBA to verify this, one way or the other.
Posted: Wed Jun 19, 2013 2:49 pm
by harikhk
Thanks Craig,
I need to verify this on my own as I do not have a dedicated DBA currently
Will post my findings