<div>
make sure you column is nvarchar<br />
then check UI that send those data to your DB. All your funky &nbsp;code looks like some conversion that happens in your front end, not in DB. DB will save whatever comes in.
</div>


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.

<div>
Ok I have nvarchar and recreated the insert script and still when I insert<br />
/æv¿/<br />
<br />
it looks like this<br />
<br />
/æv&amp;#676;/
</div>


Ok I have nvarchar and recreated the insert script and still when I insert
/æv¿/

it looks like this

/æv&#676;/

<div>
<div class="content wysiwyg-content">
What type of database collation would I use for storing properly Phonetic Symbols?<br />
<br />
Right now they store funky with the default setting of SQL 2005.<br />
see screenshot<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2010/08_w34/338708/showEE.jpg" target="_blank" title="screen (192 KB)"><img alt="screen" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2010/08_w34/800_338708/showEE.jpg" /></a>
</div>
</div>


showEE.jpg

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

 

SQL Collation Type For Phonetic Symbols

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.