SQL Collation Type For Phonetic Symbols

What type of database collation would I use for storing properly Phonetic Symbols?

Right now they store funky with the default setting of SQL 2005.
see screenshot

Who is Participating?
Lara FConnect With a Mentor EACommented:
Make sure your UI that inserts and displays your data can display and read it correctly. here is test on SQL management Studio 2008. I have da

my db collation is SQL_Latin1_General_CP1_CI_AS
create table #tmp (c1 nvarchar(128))

insert into #tmp values ('/æv¿/')
select * from #tmp

Lara FEACommented:
make sure you column is nvarchar
then check UI that send those data to your DB. All your funky  code looks like some conversion that happens in your front end, not in DB. DB will save whatever comes in.
vonfranzkenAuthor Commented:
Ok I have nvarchar and recreated the insert script and still when I insert

it looks like this

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.