Data truncation??

  • Thread starter Thread starter SSP
  • Start date Start date
S

SSP

Hi all,

Everytime I enter data into a SQL CE database using a windows form, the
entered data gets truncated.

When I view it using the Query analyser, I only see 6 characters. This only
happens with the nvarchar column types.

Is the data really getting truncated or is the query analyser set to display
only the first characters of the column?

SSP
 
Are you sure that Query analyser does not show nvarchar (6) ?
With ntext this would not happen.

Mark Johnson, Berlin Germany
(e-mail address removed)
 
Hi,

I tried this in isqlw and I was able to see all of the column value.

drop table foo;
create table foo (col nchar(20));
insert into foo values ('1234567890');
select * from foo;

So your data is probably truncated before you display it in isqlw. You can
check how you are getting the value from the form and whether the text
control has a limit on length.

Thanks,
Amy

--------------------
| From: "Mark Johnson" <[email protected]>
| Newsgroups:
microsoft.public.dotnet.framework.compactframework,microsoft.public.sqlserve
r.ce
| References: <[email protected]>
| Subject: Re: Data truncation??
| Date: Mon, 9 Feb 2004 12:55:16 +0100
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Lines: 25
| Message-ID: <[email protected]>
| Organization: Arcor
| NNTP-Posting-Date: 09 Feb 2004 12:55:20 MET
| NNTP-Posting-Host: 82.82.82.139
| X-Trace:
DXC=MPd_1KNQVT1h^:`T28h7Q<Q5U85hF6f;4jW\KbG]kaM8DAHcn;Zl5e8\18DTAok\==0keX8f
aQ?h5aOOAe2Cc4h1n4HjUacX8F9
| X-Complaints-To: (e-mail address removed)
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!npeer.de.kpn-eurorings.net!n
ewsfeed.arcor-online.net!newsread.arcor-online.net!news.arcor.de!not-for-mai
l
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.ce:11108
microsoft.public.dotnet.framework.compactframework:45285
| X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
|
| Are you sure that Query analyser does not show nvarchar (6) ?
| With ntext this would not happen.
|
| Mark Johnson, Berlin Germany
| (e-mail address removed)
| | > Hi all,
| >
| > Everytime I enter data into a SQL CE database using a windows form, the
| > entered data gets truncated.
| >
| > When I view it using the Query analyser, I only see 6 characters. This
| only
| > happens with the nvarchar column types.
| >
| > Is the data really getting truncated or is the query analyser set to
| display
| > only the first characters of the column?
| >
| > SSP
| >
| >
|
|
|
 
Back
Top