November 24, 2008 at 9:06 am
We're trying to store foreign addresses which contain non-English characters. In particular we're talking French letters. Do we need to change the data type to nvarchar from varchar?
I noticed that if I run this:
create table #t(t varchar(15))
insert into #t
select 'àâçéèêëîïôûùüÿ'
select * from #t
The data ends up in there looking just fine, so is it necessary to specify specific collation and change the data type to nvarchar?
November 24, 2008 at 9:21 am
Varchar can hold accented/marked Roman characters (like French, Spanish, German, etc.). What you need nvarchar for is Chinese characters, Arabic characters, Greek, etc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 24, 2008 at 10:54 am
Hi Luk
You dont need to change collation, i had implemented my systems for Greek characters, just changed varchar to NVarchar, but keep and eye on your drive space 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply