SQL 2005 International Language Support

Does anyone know how to store the following characters in SQL 2005?

ʓ
̽
α
₣
׀

Something like: select replace(myfield,'&#659','“') from dbo.mytable
where myfieldlike '%&#659%' returns a ?

Thanks in advance!
LVL 1
hennessymAsked:
Who is Participating?
 
BrandonGalderisiConnect With a Mentor Commented:
The ability for SSMS to display it is dependant upon the version of SSMS that you have and not necessarily the data that actually exists.
0
 
BrandonGalderisiCommented:
make the field unicode

ie:
nvarchar instead of varchar
0
 
hennessymAuthor Commented:
Thanks for the quick reply!

I should have mentioned that the field is already nvarchar.

I've also checked the boxes under Regional and Language Options to install files for complex script and right-to-left languages and files for east asian languages.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
hennessymAuthor Commented:
We have SSMS version Microsoft      9.00.3042.00 (SQL 2005 Standard Edition 64-bit, SP2).

is that a problem?
0
 
BrandonGalderisiCommented:
That is what I THINK.  I do no know definitively since I have not attempted to display those extended characters in SSMS.
0
 
hennessymAuthor Commented:
Does anyone else have any ideas?  I'm increasing the points to 500.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.