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,'ʓ','“ ') from dbo.mytable
where myfieldlike '%ʓ%' returns a ?
Thanks in advance!
ʓ
̽
α
₣
׀
Something like: select replace(myfield,'ʓ','“
where myfieldlike '%ʓ%' returns a ?
Thanks in advance!
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We have SSMS version Microsoft 9.00.3042.00 (SQL 2005 Standard Edition 64-bit, SP2).
is that a problem?
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.
ASKER
Does anyone else have any ideas? I'm increasing the points to 500.
ie:
nvarchar instead of varchar