?
Solved

SQL 2005 International Language Support

Posted on 2008-10-15
9
Medium Priority
?
219 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

800 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