Re: Why sql Server automatically change my input value.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: field properties in queries - "description" even though description ent
    ... But your code uses OpenRecordseton a *string*, i.e. the recordset is not from this saved query. ... Dim rs As DAO.Recordset ... characters respectively. ... - The fieldname for this checkbox has 55 characters ...
    (microsoft.public.access.modulesdaovba)
  • 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: field properties in queries - "description" even though description ent
    ... For each field in my query, in design view, I added a description ... Dim rs As DAO.Recordset ... characters respectively. ... If fieldnames are allowed to have 64 characters, ...
    (microsoft.public.access.modulesdaovba)
  • 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)