Search found 3 matches

by noctrex
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...
by noctrex
28.07.2011, 09:05
Forum: MS SQL Server
Topic: VARCHAR over 256 characters return always 256?
Replies: 5
Views: 3862

Thanks for your answer, I've tried the following on a test database: when using a nvarchar(max) field (I need an N* type field for encoding greek charaters) I get this error: "General SQL Server error: Check messages from the SQL Server. Unicode data in a Unicode-only collation or ntext data ca...
by noctrex
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.