SQL Server 2008 & Greek Letters

Last Post 02 Aug 2012 12:56 PM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
BlackGateTechnology
New Member
New Member

--
28 Jul 2012 02:31 PM
Unable to store greek works in sql 2008 in a text field

Example: Both are referred to as “plagues” (πληγή, πλήσσω, 8:12; 9:20; 11:6)
Result: Both are referred to as “plagues” (p????, p??ss?, 8:12; 9:20; 11:6)

Thanks for your help
rm
New Member
New Member

--
29 Jul 2012 08:07 AM
Tried with ntext data type? And need N in front of string for unicode like N'plagues'.
gunneyk
New Member
New Member

--
02 Aug 2012 12:56 PM
Yes rm is correct in that you need a unicode datatype to store them in but I would recommend a NVARCHAR() vs NTEXT going forward. Also make sure you have the correct collation specified for those objects you whish to use that in.


Acceptable Use Policy
---