Re: Invalid characters in LVarChar field
Posted in 2006
Topics: Data Types & Schema Design
You could look at the regexp blade but I've not tried it for searching for NULLs but it can detect control characters Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com Growing Old is Mandatory Growing Up is Optional Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Kennedy, Randy [mailto:RKennedy@scottsdaleaz.gov] > Posted At: 19 December 2006 12:57 > Posted To: comp.databases.informix > Conversation: Invalid characters in LVarChar field > Subject: Invalid characters in LVarChar field > > > IDS: 9.4 FC3 > O/S: HPUX 11.11 > > We have a .NET app that uses log4net to write application > exceptions to our database to help debugging. However when > it inserts the .NET exception, it inserts > nonprintable/invalid characters between each and every letter > of the exception. It makes reading the error very difficult > and we are looking for a way to remove these characters after insert. > > When using VBA to try and determine what characters these > are, they return as ASCII value of 0 (which is a null) so we > tried to use a > replace(field,NULL) statement to get rid of them to no avail. > > Any ideas on how to remove these? I saw a sample function > called char2int that returns ASCII values for given text, but > it only handles printable characters so I loose spaces, > carriage returns, etc. > > We have no control over manipulating the lvarchar before it > is inserted into the DB. > > Sample is attached since I can't cut and paste the value. > > Thanks, > Randy >