Nepali Characters In Sql Table - Sajha Mobile
SAJHA MOBILE
Nepali Characters In Sql Table
Posts 4 · Viewed 7799 · Go to Last Post
marulez
· Snapshot
Like · Likedby · 0
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?
janaandolan
· Snapshot
Like · Liked by · 0
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. 
zeran
· Snapshot
Like · Liked by · 0
Hello,
i think you can insert nepali words in nvarchar. Did you try it?
Lackadaisical
· Snapshot
Like · Liked by · 0
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
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
You might like these other discussions...
· Posts 1 · Viewed 32
· Posts 1 · Viewed 55
· Posts 15 · Viewed 3208 · Likes 3
· Posts 4 · Viewed 334
· Posts 1 · Viewed 304
· Posts 7 · Viewed 1745
· Posts 4 · Viewed 515 · Likes 1
· Posts 1 · Viewed 148
· Posts 1 · Viewed 149
· Posts 5 · Viewed 672



Your Banner Here
Travel Partners
Travel House Nepal