February 1, 2013 at 7:19 am
Hi,
I have a variable which contains a Turkish name containing four accent chars. When I insert this into a @Table it looses three of the four accents, any ideas why?
DECLARE @Person TABLE (Name nvarchar(100)
COLLATE SQL_Latin1_General_CP1_CI_AS);
INSERT INTO @Person VALUES('Çalışkan Akdağ');
SELECT * FROM @Person;
Which returns
Çaliskan Akdag
February 1, 2013 at 7:24 am
My guess is that the collation SQL_Latin1_General_CP1_CI_AS doesn't support those characters.
There is a Turkish collation: TURKISH_CI_AS, but it can still have some issues:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 1, 2013 at 7:25 am
Check, and find a one difference:
DECLARE @Person TABLE (Name nvarchar(100)
COLLATE SQL_Latin1_General_CP1_CI_AS);
INSERT INTO @Person VALUES(N'Çaliskan Akdag');
SELECT * FROM @Person;
February 1, 2013 at 7:35 am
e4d4 (2/1/2013)
Check, and find a one difference:
DECLARE @Person TABLE (Name nvarchar(100)COLLATE SQL_Latin1_General_CP1_CI_AS);
INSERT INTO @Person VALUES(N'Çaliskan Akdag');
SELECT * FROM @Person;
Ahhh, of course N''. Thanks! 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply