Re: String field length truncated to 255

Davel wrote:

> Help,
>
>
> I'm using D7, ado connecting to Microsoft sql server 2000.
>
> driver is SQLOLEDB.1 in the connection string.
>
> Now for the problem:
>
> One of the fields in the server record is a varchar 2000, and I'm
> trying to insert about 825 character string into the new record. I
> can see in the debugger at the point the Parameter is getting
> assigned, the variable to the right of the := is 825 characters of
> data but when I look at the data on the server
> after the SP or insert command completes I only see the first 255
> characters of data in Sql Query Analysis as I scroll the column to the
> right.
>
> I've tried defining
>
> addstr variable: ansistring, or just string.
>
> I have the {H+} in the unit being compiled and the project compiler
> Huge Strings is checked.
>
>
> any Ideas
>
> Thanks Dave

I figured out the problem. Microsoft's SQL Query Analysis tool only
allows the user to see the first 255 bytes of data per field returned
in the query. I had to do a len on the field in question to see that
it truely had the 825 characters stored in the database.


Question is there a good tool to look at the sql server and see what is
actually stored in each field of a record, even if it exceeds 255
characters?


Dave
.

Relevant Pages

  • Re: spoofing question
    ... > I am not at liberty to do this as I do not have SQL Server. ... The GUID suggestion was merely one way of creating an "unguessable" session ... could randomly generate a string of digits and check your db for uniqueness. ... characters, you would need 38.53 characters to cover the same range of ...
    (microsoft.public.inetserver.asp.general)
  • Re: Problem with large amount of characters in a VBA variant
    ... a SQL Server database via ODBC. ... The string is correctly stored in the Access ... variant VBA variable, but when looking at the variant with the ... I find that it has got only 255 characters (when the ...
    (comp.databases.ms-access)
  • Re: Problem with large amount of characters in a VBA variant
    ... a SQL Server database via ODBC. ... The string is correctly stored in the Access ... variant VBA variable, but when looking at the variant with the ... I find that it has got only 255 characters (when the ...
    (comp.databases.ms-access)
  • Problem with large amount of characters in a VBA variant
    ... My problem is that I have to manage a big string which can be 0 to ... SQL Server tables ... VBA variable, but when looking at the variant with the debugger, I ... find that it has got only 255 characters (when the string is 1024 ...
    (comp.databases.ms-access)
  • widestring truncated to 255 when inserted
    ... ado connecting to Microsoft sql server 2000. ... driver is SQLOLEDB.1 in the connection string. ... characters of data in Sql Query Analysis as I scroll the column to the ...
    (borland.public.delphi.database.ado)