Solved

handling macrons in sql data table - vb.net front end

Posted on 2009-04-03
3
491 Views
Last Modified: 2012-05-06
I am writing an application that has data that contains macrons (dash above charactors)

An example being Ngti Awa.

I need to be able to have a user enter the above name (including macron) and then save it in a sql server database.

I have tried saving the macron, but the macron disappers.

Do I need to set some regional settings or something ?

0
Comment
Question by:dkmarsh
  • 2
3 Comments
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24065565
two things to check are the coalation of the database and are you storing it in an NVARCHAR field that can handle those type of characters?
0
 

Author Comment

by:dkmarsh
ID: 24065736
Thanks for your comment. I have found that the collation sequence is SQL_Latin1_General_CP1_CI_AS and the column is nvarchar(50).

Can you please let me know how I would find a collation sequence that would work with the macron ?
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 250 total points
ID: 24065940
I was not sure if the coalation was the issue or not, but I knew it had to be nvarchar datatype.  I did some searching and I found this link that others have said helped them solve the problem. http://www.codeproject.com/KB/cs/multilingual_pplication.aspx
Basicly you use the 'N' character in the insert statement for the nvarchar datatype. It then accepts the unicode values and correctly stores them on the db.
There is also a prior EE post at http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21358522.html?query=korean&topics=42 you can see if it has other useful info.
HTH
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

706 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

15 Experts available now in Live!

Get 1:1 Help Now