Re: Data Type nvarchar or varchar

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

uh, twice the number of records per page is a compelling reason, IMHO

Weak reason in my opinion. First, it's not 100% of fields who are of type
characters; if you add to that the space occuped by indexes and empty space
here and there, the difference between a database based on Ascii exclusively
and one based on Unicode is usually around 30% more of space disk. Most
operations inside a database are based on numeric key and/or datetime; which
give us an upper limit of 10% slower but this is an upper limit and it will
be around 1~2% for most operations in a real case scenario excerpt for
string searching. For string searching, this will be around 20% but in the
case of string searching, we usually don't care at all about speed.

IMHO, having a Damocles' sword hanging over your head for 1% or 2% more of
performance is totally absurd.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@xxxxxxxxx> wrote in
message
news:d92058a6-5b75-465b-a5f7-fed82f612eeb@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
uh, twice the number of records per page is a compelling reason, IMHO

I think that yes, you should use varchar for almost everything,
nvarchar-- where appropriate.

-Aaron



On Oct 17, 9:43 am, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Portuguese has diacritical symbols in its alphabet, so you need to use a
code page if you want to go the ASCII road. Everytime you use a code page,
there is always a possibility that you will have problem if your data is
to
be access by a machine which doesn't use the exact same code page; so for
example someone who is greek, russian, chinese or even french - whose
alphabet is close but not identical to the portuguese - will have problem
accessing or updating your data.

If I were you, I would stop bothering myself and Unicode. There is alreay
enough problems in life so that you don't really have the need (or the
luxury) to add more to it. You database was already running fine in Access
with Unicode, why would you want to start changing things now?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

"Jose" <perd...@xxxxxxxxxxx> wrote in message

news:%23F5lHLGMJHA.2348@xxxxxxxxxxxxxxxxxxxxxxx



My data is enghish or portuguese, so, is derived from latin language.

Do you think can i change nvarchar to varchar without impact problems?
Thanks,
Jose
"Scott Lichtenberg" <do...@xxxxxxxxx> escreveu na mensagem
news:e2FWfkFMJHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
nvarchar supports Unicode data. Functionally, it's the same as varchar,
but it may require additional storage - I think Unicode requires two
bytes per character instead of one - but I could be wrong. If your data
is always going to be English (or a similar ASCII based language) you
can
switch the data types back to varchar.

"Jose" <perd...@xxxxxxxxxxx> wrote in message
news:eVHbQjEMJHA.3688@xxxxxxxxxxxxxxxxxxxxxxx
When we use upgrade wizard to migrate ms access to sql server, the
fields data type text is converted to nvarchar.
My question is, Can I change nvarchar to varchar? These changes does
it
not affect nothing?

Thanks

JCP- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Special character for Rx?
    ... Is there a standard way of assigning a Unicode value, ... Sylvain Lafontaine, ing. ... Change the Rx, if you wish, to any other combination of characters ...
    (microsoft.public.access.modulesdaovba)
  • Re: Unicode Support
    ... >> (I know this is a poor example, but think about other languages, eg ... First things first, when you register your RosAsm windows classes, you ... the messages with ANSI / UNICODE parameters in ANSI or UNICODE form... ... with their alphabet characters, as with the numbers and punctuation...so, ...
    (alt.lang.asm)
  • =?windows-1252?Q?Re=3A_Encrypting_Unicode_=96_Using_ASCII_as_a_Surrogat?= =?windows-1252?Q?e
    ... characters of an exotic eastern language using an ASCII keyboard. ... communicate in large volume with China or Japan using CJK from Unicode ... present the message text to Alice as a string of hexadecimal numbers ... by the computer as an external file and enciphered by a stream cipher ...
    (sci.crypt)
  • =?windows-1252?Q?Encrypting_Unicode_=96_Using_ASCII_as_a_Surrogate_Al?= =?windows-1252?Q?pha
    ... characters of an exotic eastern language using an ASCII keyboard. ... It is true to say that any keyboard of any language can be simulated ... communicate in large volume with China or Japan using CJK from Unicode ... by the computer as an external file and enciphered by a stream cipher ...
    (sci.crypt)
  • =?windows-1252?Q?Re=3A_Encrypting_Unicode_=96_Using_ASCII_as_a_Surrogat?= =?windows-1252?Q?e
    ... characters of an exotic eastern language using an ASCII keyboard. ... communicate in large volume with China or Japan using CJK from Unicode ... present the message text to Alice as a string of hexadecimal numbers ... by the computer as an external file and enciphered by a stream cipher ...
    (sci.crypt)