Re: Why sql Server automatically change my input value.

From: Steve Kass (skass_at_drew.edu)
Date: 08/05/04 

Date: Thu, 05 Aug 2004 09:57:31 -0400

Amy,

  The default number of characters to display per column in Query
Analyzer is 256. You can raise it as high as 8192 by changing the
setting for "Maximum characters per column" under Tools|Options|<Results
Tab> . If you're still having trouble inputting more than 100
characters, my guess is that it is something to do with how the Access
project is written. Feel free to provide more information here, but you
might post the question in one of the microsoft.public.access.* newsgroups.

Steve Kass
Drew University

Amy Tex wrote:

>Thank you, OJ. I tried in the query analyzer and enterprise manager. When I read from the enterprise manager, I have the right data. But when I use "select statement " in the query analyzer, it only gives me the first 256 characters. That's what happened to other columns too. So I guess it shouldn't be Access's problem.
>I don't have any trigger on the table. Any more input on that? Thanks a lot.
>
>"oj" wrote:
>
>
>
>>Amy,
>>
>>Can you repro the problem using Query Analyzer? If not, you might want to post
>>this to Access group to see if there is something wrong with the client app.
>>Also, check to see if the table(s) have any triggers. There might be something
>>wrong with the trigger codes.
>>
>>
>>"Amy Tex" <AmyTex@discussions.microsoft.com> wrote in message
>>news:8CD355B8-5F6D-47E9-B09F-B1D6982259CA@microsoft.com...
>>
>>
>>>I have a column, type varchar(1000). I use access project as interface to
>>>
>>>
>>interact with sql server. When I input value into the column, the server change
>>my input. It only store the first 100 something characters right. After that,
>>it replaces my input with the first 100 characters. Basically, it repeat my
>>first several sentences. Can anybody tell me why and how I should avoid this
>>problem? I really appreciate your help.
>>
>>
>>>Amy
>>>
>>>
>>
>>
>>

Relevant Pages

  • Re: Truncated Memo field displayed on form
    ... 255 characters in any column that is in the combo box's RowSource query. ... My fields down to "Knowledge and Understandings" are fine. ... occurs with the "descriptor" field being truncated on my form. ...
    (microsoft.public.access.forms)
  • Re: Using part of a field
    ... See the article "Finding and replacing characters using wildcards" at: ... AS400 SQL may have a different way of doing ... called i.dsn, containing the followiing text: ... sort of thing in a query. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Export to Ascii
    ... characters in a calculated field when you export a query. ... Modify your query to append its output to the temporary table; ... "John Nurick" wrote: ... that instead of concatenating with a delimiter it concatenates a fixed ...
    (microsoft.public.access.externaldata)
  • Re: SQL too long?
    ... I haven't done a thorough analysis here, but I suspect that the number of characters needed to express the SQL may not be as important as the number of aggregate functions like Sumand Countthat you invoke along the way. ... Although what you now have may be correct, assuming no simian behavior on the part of Access, splitting up the Query may also make it easier to debug if you later encounter any questions concerning its correctness, or if you need to revise it in some way. ... For example, in my copy of Access 2000, it says that the "Number of characters in an SQL statement" has a maximum value of "approximately 64,000", so you probably have some wiggle room there, even without using abbreviated aliases for some of the names. ... tblARTrn01.invno) INNER JOIN tblARMst01 ON tblDUPSFreight.invno = tblARMst01. ...
    (microsoft.public.access.queries)
  • Re: Problem with sql statement in VB
    ... I think that your admonition to "never use concatenation to build ... to build a second query or as parameters to a second query, ... > Of course you could use, but you never know what are special characters, ... >> searching for SQL Injection Attack. ...
    (microsoft.public.vb.database.ado)