Issue Details (XML | Word | Printable)

Key: PYFB-25
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Pavel Cisar
Reporter: nepomnyashiy evgeniy
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird driver for Python

Trancate long text from VARCHAR(5000)

Created: 26/Jan/13 09:15 PM   Updated: 07/Mar/13 01:56 PM
Component/s: None
Affects Version/s: 0.9.9
Fix Version/s: 1.0

Environment: firebird 2.5 64 bits, windows 2003R2, python 27


 Description  « Hide
I have table with field
    "field" "Text" /* "Text" = VARCHAR(5000) */,

One record have text of about 2500 chars in this field.
If I select this record, I receive only 213 chars.

cur = con.cursor()
cur.execute('SELECT "field" from "table" where id=?', [id])
for m in cur.itermap():
  print m["field"]

With kinterbasdb this works fine


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
nepomnyashiy evgeniy made changes - 26/Jan/13 09:16 PM
Field Original Value New Value
Description I have table with field
{code}
    "field" "Text" /* "Text" = VARCHAR(5000) */,
{code}

One record have text of about 2500 chars in this field.
If I select this record, I receive only 213 chars.
{code}
cur = con.cursor()
cur.execute('SELECT "field" from "table" where id=?', [id])
for m in cur.itermap():
  print m["field"]
{code}

With kinterbasdb this works fine
I have table with field
    "field" "Text" /* "Text" = VARCHAR(5000) */,

One record have text of about 2500 chars in this field.
If I select this record, I receive only 213 chars.

cur = con.cursor()
cur.execute('SELECT "field" from "table" where id=?', [id])
for m in cur.itermap():
  print m["field"]

With kinterbasdb this works fine
Pavel Cisar made changes - 06/Mar/13 01:40 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 1.0 [ 10500 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 07/Mar/13 01:56 PM
Status Resolved [ 5 ] Closed [ 6 ]