Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 17 total |
CR LF problem after export and re-import |
Wed, Jan 28 2009 9:40 AM | Permanent Link |
Uli Becker | 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 |
Wed, Jan 28 2009 11:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Jan 28 2009 12:02 PM | Permanent Link |
Uli Becker | 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 |
Wed, Jan 28 2009 1:06 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Jan 28 2009 1:19 PM | Permanent Link |
Uli Becker | Roy
> Just a question - which Delphi, Unicode or not? No Unicode. Uli |
Wed, Jan 28 2009 1:43 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Jan 28 2009 4:52 PM | Permanent Link |
Uli Becker | 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. |
Thu, Jan 29 2009 3:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Thu, Jan 29 2009 4:11 AM | Permanent Link |
Uli Becker | 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 |
Thu, Jan 29 2009 6:03 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |