[SOLVED] Fields being Truncated

[Stag76]

I've been using Lazarus v0.9.30 and ZEOS-6.6.6-Stable to extract data in a migration project from FireBird 1.5 DataBases for a year without problem, but, after updating to Lazarus v1.0 and ZEOS 7.0.1-Beta, I find that Varchar fields are being truncated when they are read from the FireBird DataBase. The truncation varies from 1 to 3 or 4 right side characters as far as I can make out. Has anybody else seen this?

[ludob]

Are there any UTF8 non ASCII characters in the VarChar fields?

[Stag76]

No, they're just text. An example is 'Street' is truncated to 'Stree', and 'AN' truncated to 'A'.

[EgonHugeist]

Can you give me a simple table and a little testcase for that? The 6.6.6 di determine the field-size oversized but it might be possible that i made a mistake for that case.  Is that field a VARYING char field?

ZeosDevTem

[Stag76]

I have a table (548 rows) of FireBird 1.5 fields, defined as Varchar (eight) . (If I use the number 8 in brackets it translates to a face). These are all being truncated to 2 characters. eg 'ANDRDE' is truncated to 'AN'. I can extract the Data to a SpreadSheet if that helps.

[EgonHugeist]

Nope i don't need a script. Hmm this is looking like a version issue to me. I've testet these modifications with FB2.5 where the Server returns Varchar(40)*SizeOf(ChracterSetChar)+SizeOf(ChracterSetChar) which means i got 123 Bytes for UTF8 as result for all SQL_VARYING types.

To determine the ColumnDisplaySize i go that way backwards.

Can you test the latest \testing branch before reacting by coding? It might be possible we've bundled a wrong rev. to this package...


Edit: What i don't know is: How does FB1.5 behave in this case?

[Stag76]

How do I get the latest testing branch to test it?

[EgonHugeist]

http://zeos.firmos.at/viewtopic.php?t=841

[EgonHugeist]

Sorry was a deprecated urL.

Have a look here: http://zeos.firmos.at/viewtopic.php?t=3431

[Stag76]

Sorry...this is beyond my capabilities.

[EgonHugeist]

I'll download a FB1.5 and test it and give you a reply the next two days.

But if that was a bug of me than is now way around to use the SVN instead of the Beta-package.

Best regards,

Michael

[Stag76]

Thanks very much. In the meantime, I'll try to work through the testing branch download.

[EgonHugeist]

Added a VirtualBox with Vista32,
Installed Lazarus 1.0.2 and FPC 2.6 (download package of SF.NET)
Installed FireBird1.5 and FlameRobin 0.9.2(to see a different behavior)
Downloaded and installed the Zeos-7.0.1-Beta package also from SF.NET

Created a DataBase with Charset Unicode_FSS and a simple table with some varchar fields in same CharSet as the DB uses with different sizes to verify the issue.

Made a simple Grid-App and:::: No issues to see.   

Now this makes me curious. Where are the differences? 

Edit: Some more Details:

Database created with flamerobin. Have 3 VARCHAR fields, size 7,8,9 AND i can use the full size. No values are trunked.
Had a mistake on my previous post: Field.Size(90) := Varchar(30)*Bytes/Char(3->Unicode_FSS)

Which Charset did you use before? Can you see diffenrence with my settings?

[Stag76]

I'll duplicate what you have done.
My FireBird 1.5 Databases are ones that were migrated (5 years ago) from Interbase.
The only difference I can see is that they have CharSet = NONE.

[Stag76]

I'm downloading Lazarus 1.0.2-fpc-win32 to re-install.

Which Version of ZEOS is recommended? Will 6.6.6-Stable work with this version of Lazarus, or will I have to
use a later one?