Hi,

I exported all tables by using the default options. After reimporting
the data I have a problem with clob-fields containing CR/LF:

Instead of this:

Mit freundlichen Grüßen

Uli Becker
xxx@t-online.de

the data ist displayed in a memo-field like the screenshot in the
binaries shows:

http://www.elevatesoft.com/newsgrp?action=downattach&group=13&msg=1674&attach=1

Any idea?

Regards Uli

Uli


If you look at the exported data how does that look? I know in DBISAM you had to have #13#10 in the text rather than the actual control codes.

Roy Lambert [Team Elevate]

Roy,

> If you look at the exported data how does that look? I know in DBISAM you had to have #13#10 in the text rather than the actual control codes.

How can I see this? When I open it in Word, it just shows the normal
LineFeed code.

Uli

Uli


I've just had a go here with a simple table in EDBManager and it works fine. The export does use the standard CRLF characters but import happily copes with them. Might be something to do with collation or character sets.

Just a question - which Delphi, Unicode or not?

Roy Lambert [Team Elevate]

Roy
> Just a question - which Delphi, Unicode or not?

No Unicode.

Uli

Uli


Can you post the table structure and a sample export to the binaries and I'll see what happens here.

Roy Lambert [Team Elevate]

Roy

> Can you post the table structure and a sample export to the binaries and I'll see what happens here.

Done. Thank you.

Uli.

Uli


Works fine here.

What I did was:

1.    Unzip to E:\Zap\Uli
2.    Open EDBManager
3.    Select a session & database I had available
4.    Run the script
5.   Create a store pointing to the directory the csv file had been dumped in
6.    Run Import using the default settings and the csv file you sent
7.    Have a look at the table in EDBManager

I have CRLF as I would expect. So assuming the import is OK it has to be the control you're using to display the data. What is it?

Roy Lambert [Team Elevate]

Roy,

> I have CRLF as I would expect. So assuming the import is OK it has to be the control you're using to display the data. What is it?

Thanks for your efforts.

I'll do the same here in order to replicate it once more. Since won't be
in town for some days it will take a while.

The component I am using is TrzMemo from the Raize4 components. I'll
check this as well.

Regards Uli

Uli


Try with standard components - that's all Tim's using in ElevateDB. The other thing to try is to examine the characters and see what you have in the clob field (ie clobfield.asstring) below #32

Roy Lambert [Team Elevate]