Frank,

<< I'd like to migrate the entire database. >>

Okay, I'll see if I can move this up in the queue - I've the ANSI/Unicode
migrators partially done, and I'll see if I can finish them for the next
build.

--
Tim Young
Elevate Software
www.elevatesoft.com

I've recently upgraded an application and EDB 2 database from Delphi 2006
ANSI to Delphi 2009 Unicode.  I've been blogging about it:
http://corneliusconcepts.com/mega_update_2.

You might also be interested in the utility I wrote to convert ANSI .CSV
files to BOM-less Unicode .CSV files.  It's mentioned in the blog.  I don't
if it's what you need, but here's a link to it:
http://corneliusconcepts.com/ansi-to-unicode.


Hope that helps!

--
David Cornelius
Cornelius Concepts

"F.J. Olthuijsen" wrote in message
news:E7866581-782E-4296-BFB8-96B72ADEE9C2@news.elevatesoft.com...
> Hi Tim,
>
> I'd like to migrate the entire database.
>
> Frank
>

Hi TIm,

that sounds great! Can you give me an estimation on when you might have the next build ready? Just to get an idea. Thanks.

Frank

"Tim Young [Elevate Software]" wrote:

Frank,

<< I'd like to migrate the entire database. >>

Okay, I'll see if I can move this up in the queue - I've the ANSI/Unicode
migrators partially done, and I'll see if I can finish them for the next
build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi David,

thank you for your reply. I'll certainly have a look.

Frank


"David Cornelius" wrote:

I've recently upgraded an application and EDB 2 database from Delphi 2006
ANSI to Delphi 2009 Unicode.  I've been blogging about it:
http://corneliusconcepts.com/mega_update_2.

You might also be interested in the utility I wrote to convert ANSI .CSV
files to BOM-less Unicode .CSV files.  It's mentioned in the blog.  I don't
if it's what you need, but here's a link to it:
http://corneliusconcepts.com/ansi-to-unicode.


Hope that helps!

--
David Cornelius
Cornelius Concepts

"F.J. Olthuijsen" wrote in message
news:E7866581-782E-4296-BFB8-96B72ADEE9C2@news.elevatesoft.com...
> Hi Tim,
>
> I'd like to migrate the entire database.
>
> Frank
>

Frank,

<< that sounds great! Can you give me an estimation on when you might have
the next build ready? Just to get an idea. Thanks. >>

Well, it was going to be by Friday or next Monday, but it may be a bit
delayed now until I can fit this stuff in.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

<< Well, it was going to be by Friday or next Monday, but it may be a bit
delayed now until I can fit this stuff in. >>

still sounds fast enough for me, thanks!

Frank

Hi Tim,

can you give me a status update? Thanks.

Frank

Frank,

<< can you give me a status update? Thanks. >>

Still working on it - I'm shooting for Monday or Tuesday of next week at
this point.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I just received the e-mail for 2.03 build 14 but saw no mention of the import/export functionality. Is that correct or did I miss something?

Frank

Frank,

<< I just received the e-mail for 2.03 build 14 but saw no mention of the
import/export functionality. Is that correct or did I miss something? >>

Sorry, I forgot to report back to you on this.  This feature is still
"hidden" for release as part of 2.04, but here's the new syntax that you can
use to "unhide" it:

IMPORT TABLE <ImportTable>
FROM <FileName>
IN STORE <StoreName>
[(<ColumnName>[,<ColumnName>])]
[ENCODING ANSI|UNICODE]    <<<<<<<<<<<<<<<<<<<<<<< Here
[DELIMITER CHAR <DelimiterChar>]
[QUOTE CHAR <QuoteChar>]
[DATE FORMAT <DateFormat>]
[TIME FORMAT <TimeFormat> [AM LITERAL <AMLiteral> PM LITERAL <PMLiteral>]]
[DECIMAL CHAR <DecimalChar>]
[BOOLEAN TRUE LITERAL <TrueLiteral> FALSE LITERAL <FalseLiteral>]
[USE HEADERS]
[MAX ROWS <MaxRowCount>]

The default for the ENCODING clause is ANSI for the ANSI version of EDB, and
vice-versa for the Unicode version of EDB.  The UNICODE option handles BOMs
also.

The EXPORT TABLE uses the exact same syntax, also right before the DELIMITER
clause, and always writes out a BOM for Unicode export files.

--
Tim Young
Elevate Software
www.elevatesoft.com