#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2002
    Posts
    1
    Rep Power
    0

    Question What's wrong with TEXT size ?


    Sorry, My Engish is so poor , please read the following carefuly:

    I installed cygwin on my win2000, the PostgreSQL works well. I use VB and psqlODBC driver to connect the database . It seemed that all are well. When I insert a string which is beyond 8K to a TEXT column , I found the TEXT column stored some rubbish date .

    The PostgreSQL is 7.2 ,
    ODBC driver is 7.2.1 downloaded from http://mirrors.sunsite.dk/postgresql...07_02_0001.zip


    I read some article . They told me that the length of a TEXT column is unlimited . Who can tell me What 's wrong with it.

    Thanks
  2. #2
  3. Second highest poster :p
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2001
    Posts
    7,322
    Rep Power
    32
    The text field is unlimited in length but PostgreSQL has a maximum size for each row of 8k. This is configurable to 32k but slows down the database. In your case it is needed so you will need to modify the configuration file for PostgreSQL to increase the size.
    - Andreas Koepke

    Koepke Photography

  4. #3
  5. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    The 8K limitation no longer exists, in latest versons of PostgreSQL (actually, for at least 2 years). See http://www.ca.postgresql.org/users-l...mitations.html

    I cannot say exactly what the problem is, but you are using on several technologies here, including VB and ODBC. Have you tried just running a simple SQL query, including more than 8K, just to see if it works? (Hint: just build a text file with an SQL query of > 8K data, then run it from the command line)

    If the query works, then you should check out VB and ODBC a little more.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2001
    Location
    Alkmaar
    Posts
    96
    Rep Power
    14
    whenever I hear ODBC my stomach gets upside down.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

    Thumbs up


    I agree with rycamor (he is the MAN on these things) and sylow.

    Try and bypass ODBC first and see what happens. Go staight to Cygwin command line and run your query before worrying about troubleshooting VB and Access.

IMN logo majestic logo threadwatch logo seochat tools logo