473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

find out storage size in DB for growth string

Hi there,

I would like to know how many storage size of nvarchar data type needs
to store in database for a growth string dynmically.

[For example] string sAccountName = "AAAAA"+"BBBBBB"+"CCCCCCCC"+......;
cmd.CommandText = "CREATE TABLE myDB.dbo.tblAccInfo(AccountName(????))

(????) mean I would like to know how many storage size exactly need to
fix in that field for sAccountName string.

How do i do for that? Any idea?

Thanks in advance.

Nov 17 '05 #1
1 1359
Jonathan Woods wrote:
Hi there,

I would like to know how many storage size of nvarchar data type needs
to store in database for a growth string dynmically.

[For example] string sAccountName = "AAAAA"+"BBBBBB"+"CCCCCCCC"+......;
cmd.CommandText = "CREATE TABLE myDB.dbo.tblAccInfo(AccountName(????))

(????) mean I would like to know how many storage size exactly need to
fix in that field for sAccountName string.

How do i do for that? Any idea?

Thanks in advance.


That is usually determined by you and your business rules when designing
the application. Some companies have standards and limit the lengths of
strings for various database fields.

Laimis
Nov 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jody Gelowitz | last post by:
Exactly what is the size limit of Isolated Storage in the Internet permission set? I have a document indicating it is 10MB (http://msdn.microsoft.com/msdnmag/issues/02/07/NetSmartClients/) ...
6
by: masri999 | last post by:
Hello, I need to monitor every 15 minutes growth in data file and log file . Since mdf and intial file sizes are set to high value, measuring these values at 15 min interval will not provide the...
5
by: aneesh | last post by:
Hi all, I have a program, this works fine but if we declare static below "int i" it shows different storage class specifier. what will be the reason. #include <stdlib.h> static int i ; int...
11
by: Sontu | last post by:
Consider the following code: int main(void) { char buffer; func(buffer); } void func(char *bufpas) {
9
by: CptDondo | last post by:
I am working on an embedded platform which has a block of battery-backed RAM. I need to store various types of data in this block of memory - for example, bitmapped data for control registers,...
8
by: ma740988 | last post by:
Consider this statement in Excel's text Thinking in C++, Vol 2: /// 1 " A vector starts by grabbing a block of storage, as if it's taking a guess at how many objects you plan to put into it. ...
14
by: Richard Harter | last post by:
Apologies for the length - this post is best viewed with fixed font and a line width >= 72. Below is the source code for a C header file that provides a suite of storage management macros. I am...
2
by: VK | last post by:
Does anyone have a reputable reference about internal string storage in JavaScript? (for some particular implementation I mean). Say having 1,048,576 characters long string from the geometric...
2
by: ibmdb2user | last post by:
Hi all, The table in question has 4 fields: UNID 19 chars DATA 2147483647 (BLOB) ROW 19 chars DT 10 chars Second column can take upto 2GB (attachments etc). So I am trying to figure out the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.