| Subject | Re: [IBO] IBO sees different VarText size than IBConsole? |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-06-06T14:22:54Z |
At 07:00 AM 06-06-01 -0700, you wrote:
This rings a bell - I believe it's an IB6 bug that occurs with ALTER COLUMN when you alter the length of a varchar - it (wrongly) adds two bytes to the new size. Claudio can confirm this when he gets round to reading these mails as I think it was he who fixed the bug in Firebird....but not before the 0.9.4 version, nor soon enough for it to have been in time for inclusion in "certified" InterBase 6...
Helen
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Unless I can reproduce this I cannot proceed. It sounds like a fluke issueJason, Luke,
>to me.
>
>Jason Wharton
>CPS - Mesa AZ
>http://www.ibobjects.com
This rings a bell - I believe it's an IB6 bug that occurs with ALTER COLUMN when you alter the length of a varchar - it (wrongly) adds two bytes to the new size. Claudio can confirm this when he gets round to reading these mails as I think it was he who fixed the bug in Firebird....but not before the 0.9.4 version, nor soon enough for it to have been in time for inclusion in "certified" InterBase 6...
Helen
>----- Original Message -----All for Open and Open for All
>From: "Lukas Zeller" <luz_info@...>
>To: <IBObjects@yahoogroups.com>
>Sent: Wednesday, June 06, 2001 1:29 AM
>Subject: [IBO] IBO sees different VarText size than IBConsole?
>
>
> > Hello,
> >
> > yesterday, I spent quite some to track down a bug which had to do with
> > VarChar field sizes.
> >
> > I have a field in a table that was created as VARCHAR(20).
> > When I dump the metadata with IBConsole, I still see VARCHAR(20).
> > However, when looking at the table with IB_WISQL, it shows
> > VarText(22) there.
> > So, IBO controls allow up to 22 chars to be input in this column.
> > In consequence, a stored procedure that tried to fetch this
> > column INTO a VARCHAR(20) caused a "string truncation" exception.
> >
> > Why and what is this difference between IBConsole metadata and
> > IBO's view? This happened only to one VARCHAR(20) field; I
> > have several others that result as expected in a VarText(20)
> > in IBO. I can reproduce the scenario by building the database
> > anew from SQL scripts, but as this is a quite complicated
> > sequence I haven't tried to extract the single table yet
> > (but I will if it helps to solve the mistery...)
> >
> > Thanks for any answer in advance!
> > --
> > Lukas Zeller (luz@...)
> > -
> > Synthesis AG, Sustainable Software Concepts
> > info@..., http://www.synthesis.ch
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________