answersLogoWhite

0

12,500 is the maximum length of a varchar field. The nVarchar field has the same limitation however you will use twice the data store space with an nVarchar as it is effectively the same as a varchar with the exception that it will store data required for international character sets. If you support a multi-language system then you will want to use a nVarchar character type for these fields.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the difference between char and varchar data types?

The CHAR datatype uses a fixed length, where as the VARCHAR datatype can be variable in length up to the maximum value specified for the length. If you insert "Hello" into a CHAR(10) field, the column would actually contain "Hello " with 5 trailing spaces. The same value inserted in a VARCHAR(10) field would contain "Hello". char datatype is fixed length data type and it store maximum 255 characters while varchardatatype store up to 4000 character of variable length datatype


Field names can be a maximum of how many characters in length?

Field names can be a maximum of _____ characters in length


What is the maximum length of field and table names?

64characters


What is the maximum length for a text field?

Enterpreneurial tripod


How do you represent Structured Query Language data types as fields?

When you create a table, you define the field names and the type of data they will contain. As an example (for Microsoft SQL Server)... CREATE TABLE SampleTable ( SampleTableID AS INT, SampleTableFirstName AS VARCHAR(50), SampleTableLastName AS VARCHAR(50), SampleTableAge AS DOUBLE ) In the above example, the field names all are prefixed with SampleTable (just for illustration) and the datatypes all follow the AS keyword.


A telephone number would be stored in a field in a database?

You can save it in NUMERIC or varchar datatype.


What is the difference between Oracle data types char and varchar2?

Character string values storage:1. CHAR:§ Stores strings of fixed length.§ The length parameter s specifies the length of the strings.§ If the string has smaller length it padded with space at the end§ It will waste of a lot of disk space.§ If the string has bigger length it truncated to the scale number of the string.2. VARCHAR:§ Stores strings of variable length.§ The length parameter specifies the maximum length of the strings§ It stores up to 2000 bytes of characters§ It will occupy space for NULL values§ The total length for strings is defined when database was created.3. VARCHAR(2):§ Stores strings of variable length.§ The length parameter specifies the maximum length of the strings§ It stores up to 4000 bytes of characters§ It will not occupy space for NULL values§ The total length of strings is defined when strings are given


How do you create admin user in php?

Have a separate field in your database and allocate the post accordingly. For eg. $query = mysql_query("CREATE TABLE IF NOT EXISTS Login ( Username varchar(12) NOT NULL Primary Key, Password varchar(12) NOT NULL, Post varchar(8), // Add more fields to your liking )"); For post allocate as admin, supervisor, etc


What length is a gaa football field?

For a standard GAA pitch the range or sizes are: Length - 130 metres minimum to 145 metres maximum Width - 80 metres minimum to 90 metres maximum


What are the dimensions of a mini football field in meters?

Minimum width: 18.30m (20 yards)Maximum width: 27.45m (30 yards)Minimum length: 27.45m (30 yards)Maximum length: 45.75m (50


Different between oracle datatypes char20 and varchar20?

In Oracle, the char(20) datatype is a fixed length character string. It will always use 20 characters in the block. If the value contained in the field is less than 20 characters, it will be padded on the right (or the left, depending on coding) with spaces. In Oracle, the varchar(20) datatype is a variable length character string. It will use betwen 1 and 21 characters in the block, 1 for the length, and 0-20 for the data. Its effective length can range between 0 and 20 characters. Note, however, that a string of length 0 is indistinguishable from a null value. This is a deviation from the SQL standard that Oracle acknowledges, but fixing it would break too much existing code. Note also that comparing a char against a varchar is problematic. With the trailiing spaces, the char is not the same as a varchar containing the same characters. Predicates involving these mixed types should use the rtrim expression on the char datatype. (Example: while rtrim(mycharvalue) = myvarcharvalue) Note also that varchar is obsolete. Current code should use varchar2, such as varchar2(20).


How wide is a pro soccer field?

It depends, the sizes can be different The minimum and maximum values for soccer field sizes are: Minimum length: 100 yards(90 meters) Maximum length: 130 yards(120 meters) Minimum width: 50 yards(45 meters) Maximum width: 100 yards(90 meters)