bug 26068 stil present in Lazarus 1.2.4 and 1.2.6 - Firebird VarChar Field lazarus / 16-Databases ---------------------------------------------------------------------- bambamns · 2014-06-22 04:22 Hi, Just to notify - first problem in bug 26068 is still present in Lazarus 1.2.4 (and 1.2.2 , too). If you have VarChar field in Firebird , with few hundreds or thousands characters (e.g. VarChar(5000) ) when you commit data it writes only first char. As I can notice , it is bug in FPC 2.6.4 and it will be fixed in FPC 2.6.5 , but FPC 2.6.5 will never be  published . ---------------------------------------------------------------------- Leledumbo · 2014-06-22 04:54 Quote from: bambamns on June 22, 2014, 06:22:09 amAs I can notice , it is bug in FPC 2.6.4 and it will be fixed in FPC 2.6.5 , but FPC 2.6.5 will never be  published . Just download and use it. As a fixes branch, despite it's updated everyday, it won't contain new bugs because no new features are added. ---------------------------------------------------------------------- LacaK · 2014-06-23 12:40 2.6.5 also does not contains this fix, because backporting is no more performed (which is in this case loss IMO) ---------------------------------------------------------------------- BigChimp · 2014-06-23 12:43 That said, the workaround mentioned in the bug report will still work. What also will work is replacing the files in your FPC source dir with those in the bug report, rebuilding FPC and recompiling Lazarus with the new FPC. ---------------------------------------------------------------------- bambamns · 2014-07-29 03:59 Hi, I had recompiled FPC and replaced db.o and db.ppu with new recompiled versions for i386-win32, and it works. How to recompile FPC for arm-wince to fix this problem on WinCe ? ---------------------------------------------------------------------- exdatis · 2014-07-29 09:45 Why not, blob sub_type 1(text)? ---------------------------------------------------------------------- marcov · 2014-07-29 15:11 Quote from: LacaK on June 23, 2014, 02:40:07 pm2.6.5 also does not contains this fix, because backporting is no more performed Not automatically anymore. If Lazarus considers out bringing out a 2.6.5 based Lazarus and has list of reports for me to look into, I'll certainly see what I can do. ---------------------------------------------------------------------- bambamns · 2014-07-30 03:58 QuoteWhy not, blob sub_type 1(text)? Because Firebird have an open issue when blob field type is filled with data on stored procedure (database expand rapidly), so I have to use VarChar field type with large number of characters. On WinCE I have problem with second part of bug report bug 26068, so I need to recompile FPC for Arm-WinCE (as I did for Win32). How to do it ? ---------------------------------------------------------------------- exdatis · 2014-07-30 05:45 Quote from: bambamns on July 30, 2014, 05:58:43 am Because Firebird have an open issue when blob field type is filled with data on stored procedure (database expand rapidly) Thanks! ---------------------------------------------------------------------- sin_dragan · 2014-10-09 05:52 Can someone explain me how to compile laz 1.2.4 with 2.6.4 to solve this. I read the bug report but I don't know how to get db.o and db.ppu which is bambamns talking about. My question is: Is there a way to compile Lazarus so I don't have to put the files from db into project directory? Sorry if I misunderstood something. EDIT: I tried to add fields.inc (whic has one line changed) and rebuild lazarus and it's the same. ---------------------------------------------------------------------- Mike.Cornflake · 2014-10-09 06:53 Quote from: sin_dragan on October 09, 2014, 07:52:57 amMy question is: Is there a way to compile Lazarus so I don't have to put the files from db into project directory? Sorry if I misunderstood something. As the issue is with fpc code, the answer is no.    No simple rebuild of Lazarus will solve the problem.  Reineir's workaround of putting files into the project folder was so your project would use those files instead of the fpc files.  It's a workaround only. Quote from: sin_dragan on October 09, 2014, 07:52:57 amCan someone explain me how to compile laz 1.2.4 with 2.6.4 to solve this. I read the bug report but I don't know how to get db.o and db.ppu which is bambamns talking about. EDIT: I tried to add fields.inc (whic has one line changed) and rebuild lazarus and it's the same. Well... the below steps are what I would do...  The tool I use is fpcup http://wiki.lazarus.freepascal.org/fpcup https://bitbucket.org/reiniero/fpcup *  Configure and use that to get yourself Lazarus 1.2.4 / fpc 2.6.4 (this means you'll have two copies on your system - the one you installed originally, and a new instance built by fpcup - the configuration step is important as out of the box fpcup will get you Lazarus Trunk/fpc Trunk) *  Apply the patch from the bugtracker to the new fpc sources. *  Configure fpcup as per the steps here: http://forum.lazarus.freepas cal.org/index.php/topic,25027.msg151310.html#msg151310 *  Re-run fpcup with -buildall. Or...   Do you have to use Lazarus 1.2.4/fpc2.6.4?    If you don't mind using trunk (where apparently this issue has been resolved) you can simplify all the above to: *  Download and run fpcup. If you go down either of these paths, please google/forum search rebuilding fpc.  Problems are likely to be encountered, and chances are good you won't be the first to have the problem you encounter.  I'd hate for you to ask a question that's been asked a million times before :-) ---------------------------------------------------------------------- sin_dragan · 2014-10-10 07:36 Thanks mike, your explanation is thorough, I prefer to use the stable release, so I'll put files in project directory. I'll try to use fpcup as you suggested and let post back my results. ---------------------------------------------------------------------- hy · 2014-10-10 18:06 so this means without customizing a lot you can not securely use firebirds VarChar Fields? I was just about to switch an existing application to firebird. But if that is the case I'd rather not... ---------------------------------------------------------------------- valdir.marcos · 2014-10-10 22:25 Quote from: hy on October 10, 2014, 08:06:12 pmso this means without customizing a lot you can not securely use firebirds VarChar Fields? Yes. Quote from: marcov on July 29, 2014, 05:11:38 pmQuote from: LacaK on June 23, 2014, 02:40:07 pm2.6.5 also does not contains this fix, because backporting is no more performed Not automatically anymore. If Lazarus considers out bringing out a 2.6.5 based Lazarus and has list of reports for me to look into, I'll certainly see what I can do. Since many people are already using FPC 2.7.1 (unstable), should not Lazarus 1.2.6 has a second download option with FPC 2.7.1 to help beginners? ---------------------------------------------------------------------- valdir.marcos · 2014-10-10 22:54 Does anybody can help us with estimated‎ dates on FPC schedulling for 2.8.0 or 3.0.0? ---------------------------------------------------------------------- bambamns · 2014-10-18 02:51 @sin_dragan, Compile FPC (2.6.4) with new dbo files. Try to read and apply http://forum.lazarus.freepascal.org/index.php/to pic,16839.msg92122.html#msg92122