Search found 3 matches
- 28.07.2011, 09:54
- Forum: MS SQL Server
- Topic: VARCHAR over 256 characters return always 256?
- Replies: 5
- Views: 3862
Small quick'n'dirty workaround for this issue: I just split, inside the sql query, the long varchar into pieces of 250 chars like this: SUBSTRING(ISNULL(Ap_Memo, ''''), 0, 250) AS Ap_Memo01, SUBSTRING(ISNULL(Ap_Memo, ''''), 250, 250) AS Ap_Memo02, SUBSTRING(ISNULL(Ap_Memo, ''''), 500, 250) AS Ap_Mem...
- 28.07.2011, 09:05
- Forum: MS SQL Server
- Topic: VARCHAR over 256 characters return always 256?
- Replies: 5
- Views: 3862
- 28.07.2011, 08:13
- Forum: MS SQL Server
- Topic: VARCHAR over 256 characters return always 256?
- Replies: 5
- Views: 3862
VARCHAR over 256 characters return always 256?
I have a database in which there are many VARCHAR(1000) fields, but it seems that zeos 6.6.6 always returns only the first 256 charaters.
Is there a solution for this problem?
I cannot alter the database, so I must find a solution within delphi.
Is there a solution for this problem?
I cannot alter the database, so I must find a solution within delphi.