Re: Data Type nvarchar or varchar

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <donot@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" <perdijc@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





.