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?