DELPHI BDE CONNECTION TO SQL

• shaunmoolman

  Valued Member

  Points: 67

  More actions

  November 28, 2003 at 4:09 am

  #65580

  When I update a column in SQL defined as TEXT with a string longer than 255, the update converts to a couple of special characters, instead of the long description. I am using an ODBC connection with the Borland DataBase Engine. I have tried using varchar (1500) which works in Oracle and Interbase, but not in SQL. Can you help?

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  November 30, 2003 at 10:29 am

  #484053

  I've seen something similar when working with BDE, setting the blob size to a higher number in the BDE worked for me.

  HTH

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA

• Goce Smilevski

  SSCommitted

  Points: 1704

  More actions

  December 2, 2003 at 12:35 am

  #484218

  Delphi treats TEXT fields as ftMemo. Try setting FieldType to ftString manually. Also, I agree with the provious suggestion about higher BLOB SIZE value.