Nepali Characters In Sql Table

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.
Start a New Discussion
Archived Post

I have table with two columns, English and Nepali. I am trying to insert english word in english column and nepali word in nepali column in Sql Management Studio. How can i do that?

marulez · Mar 7, 2010 8:06 PM · 18,041 views

3 Replies

Even I am looking for the same. But my database server is MySQL. I want to create database in Nepali font and finally want to display in web browser. Any help or suggestion would be greatly appreciated. 

janaandolan · Mar 8, 2010 8:12 AM

Hello,i think you can insert nepali words in nvarchar. Did you try it?

zeran · Mar 8, 2010 10:05 AM

On top of using nvarchar data type you also need to implement "N" in front of the string to be inserted in any other script than the default server language/colation. INSERT INTO MyTable(EnglishCol, NepaliCol) VALUES ('English Name', N'नेपाली नाम') This is specific for MS-SQL and might not be same for MySQL Last edited: 08-Mar-10 10:35 AM Last edited: 08-Mar-10 10:36 AM

lackadaisical · Mar 8, 2010 10:34 AM

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.

Start a New Discussion

You might be interested in...

Latest Community News View all
Page 1 of 9
Recent Classifieds View all
Page 1 of 28
Upcoming Events View all
Page 1 of 2
Service Providers View all
Page 1 of 21