Hi,
I am new to MS SQL. When I create a column in a table, when shall I
use nvarchar or varchar? Please help.
Thanks,
Mike
5  18317 
The nvarchar data type provides support for Unicode characters. This is
needed if you are building an international system that must store different
languages. However, if you have no need to store Unicode characters then you
are better using varchar. The nvarchar data type occupies twice the space of
varchar as it uses 2 bytes to encode each character.
HTH,
Plamen Ratchev http://www.SQLStudio.com
On 26 Feb, 15:13, "Plamen Ratchev" <Pla...@SQLStudio.comwrote:
The nvarchar data type provides support for Unicode characters. This is
needed if you are building an international system that must store different
languages. However, if you have no need to store Unicode characters then you
are better using varchar. The nvarchar data type occupies twice the space of
varchar as it uses 2 bytes to encode each character.
HTH,
Plamen Ratchevhttp://www.SQLStudio.com
varchar will support a lot of characters from different languages
though (depending on the collation codepage) so no need to rush into
doubling your storage if you dont "really" need to
On Feb 26, 10:26 am, "oliver" <oraus...@hotmail.comwrote:
On 26 Feb, 15:13, "Plamen Ratchev" <Pla...@SQLStudio.comwrote:
The nvarchar data type provides support for Unicode characters. This is
needed if you are building an international system that must store different
languages. However, if you have no need to store Unicode characters then you
are better using varchar. The nvarchar data type occupies twice the space of
varchar as it uses 2 bytes to encode each character.
HTH,
Plamen Ratchevhttp://www.SQLStudio.com
varchar will support a lot of characters from different languages
though (depending on the collation codepage) so no need to rush into
doubling your storage if you dont "really" need to
Plamen, Oliver Thanks a lot!
Mike
On Feb 26, 9:47 am, haid...@gmail.com wrote:
Hi,
I am new to MS SQL. When I create a column in a table, when shall I
use nvarchar or varchar? Please help.
Thanks,
Mike
Mike,
Clearly you need to go back to reading the manual or get a Dummy's
book if you don't know the difference between unicode and ascii
strings.
HTH,
Carl Tegeder
Master MS-SQL Administrator
Carl Tegeder wrote:
>I am new to MS SQL. When I create a column in a table, when shall I
use nvarchar or varchar? Please help.
Clearly you need to go back to reading the manual or get a Dummy's
book if you don't know the difference between unicode and ascii
strings.
Not the most tactful of responses, but hey.
To the original poster: Google and Wikipedia are your friends. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Vani Kancherlapalli |
last post by:
Hi
The maximum length of a nvarchar could be 4000 characters while that of
varchar could be 8000.
We are trying to use unicode which would require that the datatype for
one our fields be...
|
by: Oleg Ogurok |
last post by:
Hi all,
I need to store data into about 104 columns. This is problematic with MS
SQL, since it doesn't support rows over 8kb in total size.
Most of the columns are of type NVARCHAR(255), which...
|
by: wriggs |
last post by:
Hi,
This is probably an easy question for someone so any help would be
appreciated.
I have changed the columns in a table that where nvarchar to the same
size of type varchar so halve the...
|
by: D. |
last post by:
Hi, I'm starting a new application in java using JTDS jdbc driver
(http://jtds.sourceforge.net) and SQLServer 2005 Express.
I have to design the database from scratch and my doubt is if I have to...
|
by: Srikanthk |
last post by:
Dear Sir,
What is the Difference using varchar and nvarchar in Oracle 9i.
|
by: stuckish |
last post by:
My collegue is saying that you should store text data in Sql Server i
unicode fields (nvarchar) beause that .net (asp.net website) is all
unicode and therefore you save some time not having to...
|
by: bharathreddy |
last post by:
Here i will show the differences between nvarchar and varchar:
The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in the database tables....
|
by: Mark B |
last post by:
When I click the 'Update' button on a ASP.Net 3.5 GridView record, I get an
error:
Incorrect syntax near 'nvarchar'.
Everything else there works OK. Here is the code:
<%@ Page...
|
by: leedatkinson |
last post by:
Hi, I'm pretty new to using SQL as a long standing Access users all these field types are a bit much... I have a ntext field that I need to convert to a nvarchar. I have tried cast and convert and as...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
