> -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > Womack, Adrian > Sent: Wednesday, September 16, 2009 6:06 PM > To: U2 Users List > Subject: Re: [U2] Null character causes odd UV behaviour > > > Have you tried CONVERT @NULL.STR TO "" IN STATE > > (for info on @NULL.STR see "@variables" in the BASIC help file)
I don't have an easy way to test that at the moment since my workaround resulted in all the bad data getting cleared out. I would expect the same result, though, since @NULL.STR is just a placeholder for CHAR(128). The really odd thing is that this code didn't produce any errors: 0001: OPEN 'CF' TO FILE.CF ELSE STOPM 'NO CF FILE' 0002: STATE = CHAR(128) 0003: CONVERT CHAR(128) TO '' IN STATE 0004: READV DUM FROM FILE.CF, 'STA*':STATE, 1 ELSE NULL Same file, same character, same ID, but the character didn't come over from SQL via ODBC. Apparently the one I got from SQL was a "special" CHAR(128). -John _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
