While working on a conversion of an application and EDB database from Delphi
2006 ANSI to Delphi 2009 Unicode, the conversion of the exported ANSI text
files to Unicode format tripped me up a little.  Searching the internet for
a command-line utility showed a few, but none that did quite what I wanted.
What do programmers do when they run into a situation like this?  They write
their own program, of course!

The attached is the source code to such a conversion utility.  Although it
is not a simple command-line utility, but a full Windows application, it
will convert a whole folder of text files to the proper format needed to
import into an ElevateDB 2.03 Unicode database.  It requires Delphi 2009 or
greater.

If you want to see a screen shot, click here:
http://corneliusconcepts.com/files/AnsiToUnicodeScreenShot.png.

If you want to download just the application and don't care about the source
code, visit my web site: http://corneliusconcepts.com/ansi-to-unicode.

--
David Cornelius
Cornelius Concepts

David,

<< The attached is the source code to such a conversion utility. >>

Cool, thanks very much.

--
Tim Young
Elevate Software
www.elevatesoft.com

You bet.  I figured it would be obsolete soon when you put out a version of
EDB Manager that can export to Unicode files with the stripped BOM, but I
learned some stuff in the process!

--
David Cornelius
Cornelius Concepts


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:2F1394EA-6882-43B8-A1F8-9071B076BE41@news.elevatesoft.com...
> David,
>
> << The attached is the source code to such a conversion utility. >>
>
> Cool, thanks very much.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

David,

<< You bet.  I figured it would be obsolete soon when you put out a version
of EDB Manager that can export to Unicode files with the stripped BOM, but I
learned some stuff in the process! >>

Actually, it's the opposite - EDB can only deal with BOM-less Unicode files
right now, as far as import/export is concerned.   The EDB Manager itself
can deal with any type of .sql file just fine.

--
Tim Young
Elevate Software
www.elevatesoft.com