Solved

SQL 2005 International Language Support

Posted on 2008-10-15
9
203 Views
Last Modified: 2012-05-05
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!
0
Comment
Question by:hennessym
  • 3
  • 3
9 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22724661
make the field unicode

ie:
nvarchar instead of varchar
0
 
LVL 1

Author Comment

by:hennessym
ID: 22725171
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
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 22725206
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Author Comment

by:hennessym
ID: 22725265
We have SSMS version Microsoft      9.00.3042.00 (SQL 2005 Standard Edition 64-bit, SP2).

is that a problem?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22725525
That is what I THINK.  I do no know definitively since I have not attempted to display those extended characters in SSMS.
0
 
LVL 1

Author Comment

by:hennessym
ID: 22725807
Does anyone else have any ideas?  I'm increasing the points to 500.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question