Solved

SQL Collation Type For Phonetic Symbols

Posted on 2010-08-19
3
1,045 Views
Last Modified: 2012-05-10
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

 screen
0
Comment
Question by:vonfranzken
  • 2
3 Comments
 
LVL 11

Expert Comment

by:Larissa T
ID: 33474923
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.
0
 

Author Comment

by:vonfranzken
ID: 33475088
Ok I have nvarchar and recreated the insert script and still when I insert
/æv¿/

it looks like this

/ævʤ/
0
 
LVL 11

Accepted Solution

by:
Larissa T earned 500 total points
ID: 33475517
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



0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now