Groups > comp.lang.basic.visual.misc > #890

Re: How to handle LARGE UTF-8 file

From	stevegdula@yahoo.com
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: How to handle LARGE UTF-8 file
Date	2012-03-08 10:49 -0800
Organization	http://groups.google.com
Message-ID	<20959473.1240.1331232566638.JavaMail.geo-discussion-forums@vbze11> (permalink)
References	<29897294.1014.1331222704653.JavaMail.geo-discussion-forums@vblb5> <jjao9g$sis$1@speranza.aioe.org> <jjat0a$j6n$1@dont-email.me>

Show all headers | View raw

>-- Deanna,
>While the data may be UTF-8 format, will it actually contain 
>any "non ascii" text?  UTF-8 and ASCII are identical for the
>first 128 code points.

Unfortunately this is part of the conumdrum.  This is a delimited text export where the source used ASCII(20) to delimit the fields and ASCII(254) to qualify the field content.

>-- Bob,
>If it does have any special characters you should be able to leverage
>the WideCharToMultiByte API call to convert from UTF8 to Unicode and
>then figure out what to do with the special characters for inserting
>into the database. 

Thanks all !  I will look into using the 'WideCharToMultiByte' api call to see if I can parse this data into ANSI text.

~Steve

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to handle LARGE UTF-8 file stevegdula@yahoo.com - 2012-03-08 08:05 -0800
  Re: How to handle LARGE UTF-8 file Deanna Earley <dee.earley@icode.co.uk> - 2012-03-08 16:55 +0000
    Re: How to handle LARGE UTF-8 file "Bob Butler" <bob_butler@cox.invalid> - 2012-03-08 10:13 -0800
      Re: How to handle LARGE UTF-8 file stevegdula@yahoo.com - 2012-03-08 10:49 -0800
  Re: How to handle LARGE UTF-8 file "Farnsworth" <nospam@nospam.com> - 2012-03-08 16:00 -0500
    Re: How to handle LARGE UTF-8 file "Farnsworth" <nospam@nospam.com> - 2012-03-08 16:05 -0500
      Re: How to handle LARGE UTF-8 file stevegdula@yahoo.com - 2012-03-08 17:51 -0800
        Re: How to handle LARGE UTF-8 file "Farnsworth" <nospam@nospam.com> - 2012-03-08 23:32 -0500
        Re: How to handle LARGE UTF-8 file Schmidt <sss@online.de> - 2012-03-09 07:32 +0100
          Re: How to handle LARGE UTF-8 file "Farnsworth" <nospam@nospam.com> - 2012-03-09 13:40 -0500
            Re: How to handle LARGE UTF-8 file stevegdula@yahoo.com - 2012-03-14 08:54 -0700

csiph-web