October 29, 2009 at 6:01 am
Hi all,
Quick question for you, I have a column with a datatype VARCHAR and I want to store a character in it of (ł) which belongs to a different language. Any idea's on how I can store this and other characters?
My collation is the default Latin1 CI AS, i've tried changing the column data type to NVARCHAR and then also tried a different collation for the column.
Any help would be great.
Thanks,
October 29, 2009 at 6:17 am
One thing I have noticed is that if I create a new db with a collation of Polish CI AS and then create the column in a table (same collation) with a NVARCHAR datatype then the character is stored.
Does this mean the db and column collations must match?
Thanks,
October 29, 2009 at 6:44 am
Hi all,
Got this working, the db collation remains in the default as does the column but it is created as an NVARCHAR, the data is stored, turns out that i'd missed putting the 'N' before the SELECT, doing this means it returns correctly.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply