[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1091
  • Last Modified:

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

 screen
0
vonfranzken
Asked:
vonfranzken
  • 2
1 Solution
 
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.
0
 
vonfranzkenAuthor Commented:
Ok I have nvarchar and recreated the insert script and still when I insert
/æv¿/

it looks like this

/ævʤ/
0
 
Lara FEACommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now