Default STRING data type length
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Default STRING data type length

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
gwheeloc
Guest





Posted: Fri Feb 18, 2005 5:39 am    Post subject: Default STRING data type length Reply with quote

I'm new to Commerce Server and I need to add new data members to the
profile catalog.

It seems like when I use the CS Manager MMC the STRING data type
defaults to NVARCHAR(50). I understand the datatype needs to stay as
NVARCHAR, but Can I change the size of the field? I understand there
are size restrictions like <= 3600.

Thank you
gwheeloc
Back to top
Andre Podnozov [MSFT]
Guest





Posted: Sat Feb 19, 2005 6:48 am    Post subject: RE: Default STRING data type length Reply with quote

You should be able to go into SQL Enterprise Manager, find the table that
corresponds to your data object, and modify the field length to the desired
value.

Thanks
Andre

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.


--------------------
From: "gwheeloc" <gwheeloc@hotmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Default STRING data type length
Date: 17 Feb 2005 15:39:44 -0800
Organization: http://groups.google.com
Lines: 11
Message-ID: <1108683583.952641.314640@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 207.127.103.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1108683592 27967 127.0.0.1 (17 Feb 2005
23:39:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 17 Feb 2005 23:39:52 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=207.127.103.2;
posting-account=piW6Kw0AAACa2Lw10OlK_sSZH9bkw1vk
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-fo
r-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:2253
X-Tomcat-NG: microsoft.public.commerceserver.general

I'm new to Commerce Server and I need to add new data members to the
profile catalog.

It seems like when I use the CS Manager MMC the STRING data type
defaults to NVARCHAR(50). I understand the datatype needs to stay as
NVARCHAR, but Can I change the size of the field? I understand there
are size restrictions like <= 3600.

Thank you
gwheeloc
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB