Text insert problem in the database
-
Hi All, I am inserting (copy and paste Chinese language text) in the textbox and try to insert them in the database ,i have used nvarchar(max) column type in the table it gives me ??????? mark in the table value after insertion of text when i displayed it on the asp.net page it display ??? mark in the grid . and when i directly copy this text in the table value it show me the chinese language why ? it not working ? inspite of i have took unicode type I want to make multi-lingual site can any body help me
To the person who gave me a 1, if you're the OP, try answering me when I try to help you instead, if you're not, you answer his question if you want to disuade me from trying to help.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
-
no ,here is one textbox and submit button in asp.net(vb) when i enter any Chinese language (copy text from MSword and paste it in the textbox) and click submit button on that button i am doing the insert data in the data base but the data which is going to insert is not in the same form which i have entered. Got it ? it insert ?????? in the table field. show the code below
Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim MyConnection As SqlConnection Dim cmd As SqlCommand MyConnection = New SqlConnection() MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString MyConnection.Open() cmd = New SqlCommand("Select * from empl", MyConnection) GridView1.DataSource = cmd.ExecuteReader() GridView1.DataBind() MyConnection.Close() End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim MyConnection As SqlConnection Dim cmd As SqlCommand MyConnection = New SqlConnection() MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString MyConnection.Open() 'Dim MySQL As String = "Insert into NewEmp (fname, LName, Address, City, State, Postalcode, Phone, Email) Values (@Firstname, @LastName, @Address, @City, @State, @Postalcode, @Phone, @Email)" Dim MySQL As String = "Insert into empl (name1) Values (@name1)" cmd = New SqlCommand(MySQL, MyConnection) cmd.Parameters.Add(New SqlParameter("@name1", SqlDbType.VarChar, 11)) cmd.Parameters("@name1").Value = TextBox1.Text cmd.ExecuteNonQuery() MyConnection.Close() End Sub End Class -
no ,here is one textbox and submit button in asp.net(vb) when i enter any Chinese language (copy text from MSword and paste it in the textbox) and click submit button on that button i am doing the insert data in the data base but the data which is going to insert is not in the same form which i have entered. Got it ? it insert ?????? in the table field. show the code below
Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim MyConnection As SqlConnection Dim cmd As SqlCommand MyConnection = New SqlConnection() MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString MyConnection.Open() cmd = New SqlCommand("Select * from empl", MyConnection) GridView1.DataSource = cmd.ExecuteReader() GridView1.DataBind() MyConnection.Close() End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim MyConnection As SqlConnection Dim cmd As SqlCommand MyConnection = New SqlConnection() MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString MyConnection.Open() 'Dim MySQL As String = "Insert into NewEmp (fname, LName, Address, City, State, Postalcode, Phone, Email) Values (@Firstname, @LastName, @Address, @City, @State, @Postalcode, @Phone, @Email)" Dim MySQL As String = "Insert into empl (name1) Values (@name1)" cmd = New SqlCommand(MySQL, MyConnection) cmd.Parameters.Add(New SqlParameter("@name1", SqlDbType.VarChar, 11)) cmd.Parameters("@name1").Value = TextBox1.Text cmd.ExecuteNonQuery() MyConnection.Close() End Sub End Classamistry_petlad wrote:
SqlDbType.VarChar
Not NVarChar ?
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
-
To the person who gave me a 1, if you're the OP, try answering me when I try to help you instead, if you're not, you answer his question if you want to disuade me from trying to help.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
sorry for that i didnt get properly so I have click "no" "sorry about that " Please help me out
-
sorry for that i didnt get properly so I have click "no" "sorry about that " Please help me out
I am happy to help you either way - I just find I get a lot of 1's when I try to help, and I don't know why. Did changing it to nvarchar help ?
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
-
I am happy to help you either way - I just find I get a lot of 1's when I try to help, and I don't know why. Did changing it to nvarchar help ?
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
sorry :omg: you are really helpful but due to my foolness you miss the one point how can i help you to reward back this point sir.? can you provide me one more help? how can i directly type any language in the web page once i download the font ? can you help me ?
-
sorry :omg: you are really helpful but due to my foolness you miss the one point how can i help you to reward back this point sir.? can you provide me one more help? how can i directly type any language in the web page once i download the font ? can you help me ?
Well, the user needs to have thier PC set up to be typing in that language. For testing, you can install more than one language, you can set up the language bar in your menu bar with a right click and choose the option ( I'd check for details, but I am on a mac ). Then you can choose different languages and work out how the keyboard works to enter them when they are selected.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
-
Well, the user needs to have thier PC set up to be typing in that language. For testing, you can install more than one language, you can set up the language bar in your menu bar with a right click and choose the option ( I'd check for details, but I am on a mac ). Then you can choose different languages and work out how the keyboard works to enter them when they are selected.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
no , I didn't get you can you briefly elaborate me. so i can get better idea.
-
no , I didn't get you can you briefly elaborate me. so i can get better idea.
You can't make a user have access to a language, they need to configure their PC for it. I can't give more specific help than I gave b/c I am on a mac, I can't try it to reproduce, but I know on the task bar I have a language menu which lists languages I can pop between.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
-
You can't make a user have access to a language, they need to configure their PC for it. I can't give more specific help than I gave b/c I am on a mac, I can't try it to reproduce, but I know on the task bar I have a language menu which lists languages I can pop between.
Christian Graus Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
thanks this is for u :rose: