[AccessD] Zero-width characters in query

Stuart McLachlan stuart at lexacorp.com.pg
Thu May 25 15:26:37 CDT 2017


Someone must have imported a badly structured text file into the database :(


On 25 May 2017 at 8:20, Charlotte Foust wrote:

> I tried that, but the first character wasn't null, it was a chr(9).  I
> replaced it with a null string to cure the craziness.
> 
> Charlotte Foust
> 916-206-4336
> 
> On May 25, 2017 7:56 AM, "Rocky Smolin" <rockysmolin at bchacc.com>
> wrote:
> 
> > Not a solution but if you retrieved the second character in the
> > string in the event that the fist character was blank or null, would
> > that second character actually be the first character in the string?
> >  Or be the second character?
> >
> > Rocky
> >
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > Behalf Of Charlotte Foust Sent: Wednesday, May 24, 2017 10:49 PM To:
> > Access Developers discussion and problem Subject: [AccessD]
> > Zero-width characters in query
> >
> > I ran into something today that left me scratching my head.  I ran a
> > query to extract the first letter of a company name to use as an
> > index.  About 42 out of some 60k came back empty and no editing I
> > could do would change that.
> >
> > I hunted around the internet and found a few issues with SharePoint
> > and Unicode but nothing that made sense in context.  Have any of you
> > ever happened on this?  I found a way to fix the fields, because i
> > could find no way to query around it.  The length of the string was
> > for the visible characters, but the first character wasn't visible.
> >
> > Charlotte Foust
> > 916-206-4336
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list