|
[VIEWED 9249
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
marulez
Please log in to subscribe to marulez's postings.
Posted on 03-07-10 8:06
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
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
Please log in to subscribe to janaandolan's postings.
Posted on 03-08-10 8:12
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
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
Please log in to subscribe to zeran's postings.
Posted on 03-08-10 10:05
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Hello, i think you can insert nepali words in nvarchar. Did you try it?
|
| |
|
|
Lackadaisical
Please log in to subscribe to Lackadaisical's postings.
Posted on 03-08-10 10:34
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
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
|
| |
