This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello - I'm attempting to connect using ODBC driver via DBeaver, with the Netsuite2 Data Source; I can query tables, but string data fields seem to all be NULL. I'm trying to find where I can adjust String Types=Ansi but can't see where to set this - has anyone done this successfully or have any ideas?

I just tried the same query in RazorSQL and I don't have any issues there. Must be something about DBeaver I can't figure out how to set.

My query:
```SELECT t.id, tl.id, tal.account, t.trandate, a.fullname
FROM transaction t, transactionLine tl, TransactionAccountingLine tal, account a
where t.id=939035 
and tl.transaction = t.id 
and tal.transactionline = tl.id
and tal.transaction = t.id
and tal.account = a.id```

I was able to get it to work in DBeaver by using: `TO_CHAR(a.fullname)`