This is when using JDBC and the <NetSuite2.com> sc...
# suiteanalyticss
scottvonduhn
02/07/2022, 8:42 PMThis is when using JDBC and the NetSuite2.com schema, if it makes a difference
d
dynamicl
02/08/2022, 10:40 AMWhat table and field are you looking at?
s
scottvonduhn
02/08/2022, 1:42 PMA custom Long Text field on the Customer record:
SELECT entitytitle, custentity_seasonal_notes FROM customerscottvonduhn
02/08/2022, 1:44 PMIt was a mistake made by a past admin to make custentity_seasonal_notes Long Text. Most of the entries are very short, nearly all less than 100 characters. Maybe some up to 200.
d
dynamicl
02/08/2022, 4:42 PMLooks like a similar issue my side, schema 1 is ok ...
dynamicl
02/08/2022, 4:42 PMmessage has been deleted
dynamicl
02/08/2022, 4:43 PMv2 ...
dynamicl
02/08/2022, 4:43 PMmessage has been deleted
dynamicl
02/08/2022, 4:50 PMSorry, should have said this is ODBC not JDBC
s
scottvonduhn
02/08/2022, 4:51 PMYeah, I think there are similar issues related to these fields, whether via ODBC or JDBC. I wonder if some kind of formula or function would work to extract the text
d
dynamicl
02/08/2022, 4:55 PMsomething like CAST might do it via SQL, just going to try a couple of things
dynamicl
02/08/2022, 4:59 PMmessage has been deleted
dynamicl
02/08/2022, 4:59 PMnon starter by the looks of it
s
scottvonduhn
02/08/2022, 5:08 PMwell this is disappointing. How can Netsuite deprecate the old schema if the new one can't even retrieve the same data?