Varchar greater than 255 characters

George

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Varchar greater than 255 characters

Hi
I am using D4 + BDE 5.10 + SQL 7 on Win98. I have got a column in a table
created as varchar(1000) and a DBMemo control in a form that shows its
contents.
Unfortunately I cannot insert more than 255 characters using that
combination. What is the solution to that problem?

TIA
George

Fabiano Boni

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Varchar greater than 255 characters

The solution is to use the 'Text' datatype, not 'varchar'.
The 'Text' datatype is used specifically to store texts.

"George" <macs...@compulink.gr> escreveu na mensagem
news:8jcesc$edh1@bornews.borland.com...

Quote

> Hi
> I am using D4 + BDE 5.10 + SQL 7 on Win98. I have got a column in a table
> created as varchar(1000) and a DBMemo control in a form that shows its
> contents.
> Unfortunately I cannot insert more than 255 characters using that
> combination. What is the solution to that problem?

> TIA
> George

Euan Garde

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Varchar greater than 255 characters

This is because the SQL Links driver uses DBLib which does not support > 255
chars or unicode. You need to swith to ODBC or OLE DB(ADO)

-Euan

Quote

"George" <macs...@compulink.gr> wrote in message

news:8jcesc$edh1@bornews.borland.com...

Quote

> Hi
> I am using D4 + BDE 5.10 + SQL 7 on Win98. I have got a column in a table
> created as varchar(1000) and a DBMemo control in a form that shows its
> contents.
> Unfortunately I cannot insert more than 255 characters using that
> combination. What is the solution to that problem?

> TIA
> George

Other Threads

1. problens w/ varchar greater than 255

2. problens with MSSQL 7.0 with varchar greater than 255

3. Will Delphi 4.0 accept VarChars greater than 255.

4. SQL Server 7 Varchar field greater than 255

5. MSSQL Varchar Fields beyond 255 characters

6. Varchar(255) vs Varchar(256) and TStrigField vs TMemoField

7. network broadcast to 255.255.255.255 or x.x.x.255 doesn't work

8. Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

9. PChar: I need greater than 255

10. Strings greater than 255