Page 1 of 1

strings encased in 'n'

PostPosted: Wed Oct 07, 2015 6:33 pm
by Patti
I am using Dbeaver to extract from a db2 database to a pipe delimited file. A few of my character columns are encased in 'n'. It is weird because the second column is a character column and does not come across with the n's. However, the third column is a character column and it does come through encased in n's.

| |MU|n01n|CR|TR|3778

The sixth column is numeric and it is coming across fine. The only thing I can see different is that the third column is defined as character but contains a number?