Link to home
Start Free TrialLog in
Avatar of hennessym
hennessym

asked on

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!
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

make the field unicode

ie:
nvarchar instead of varchar
Avatar of hennessym
hennessym

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
We have SSMS version Microsoft      9.00.3042.00 (SQL 2005 Standard Edition 64-bit, SP2).

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