|
Posted by Jack Vamvas on 05/10/06 12:59
what is the nature of the data you are storing?
varchar sores variable length non-Unicode
nvarchar stores variable length Unicode
Essentially if your not storing multilingual data use varchar , as nvarchar
takes up twice as much storage space.
--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"D." <d@d.com> wrote in message news:e3qd4l$tri$1@newsreader.mailgate.org...
> 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
use
> varchar or nvarchar fields to store string data.
>
> Any experience about performance issues using nvarchar instead of varchar
> (considering that Java internally works in unicode too)?
>
> Thanks in advance,
> Davide.
>
>
Navigation:
[Reply to this message]
|