Solved

SQL 2005 International Language Support

Posted on 2008-10-15
9
215 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 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

687 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