Problem in inserting "Hindi" Text in MySql5.0 using ASP.Net
-
Hello all, I want to insert a Hindi text value into a mysql5.1 database from an asp.net TextBox when a "INSERT" button is clicked. And I also want to retrive the same value from MySql5.1 to an asp.net TextBox when a "SHOW" button is clicked. Please help me how this will be possible. I am uinging Visual Studio 2005 and C# for code behind. Thanks in advance.
-
Hello all, I want to insert a Hindi text value into a mysql5.1 database from an asp.net TextBox when a "INSERT" button is clicked. And I also want to retrive the same value from MySql5.1 to an asp.net TextBox when a "SHOW" button is clicked. Please help me how this will be possible. I am uinging Visual Studio 2005 and C# for code behind. Thanks in advance.
to do this, u can change data type of your table field to nVarchar. Then u will be able to insert & fetch the text of any language in database.
Regards... Vijay Jain :)
"One thing you can't recycle is wasted time."
-
to do this, u can change data type of your table field to nVarchar. Then u will be able to insert & fetch the text of any language in database.
Regards... Vijay Jain :)
"One thing you can't recycle is wasted time."
Hi Vijay, Thanks a lot for replying,I tried it but there is no any DataType named nVarchar in MySql5.1 the same database working fine with php 5.1 code. but with asp.net when i try to use the same query it's sowing the value like '???????' in database after insertion.
-
Hi Vijay, Thanks a lot for replying,I tried it but there is no any DataType named nVarchar in MySql5.1 the same database working fine with php 5.1 code. but with asp.net when i try to use the same query it's sowing the value like '???????' in database after insertion.
actually i have never worked on 5.1 version. but no problem, i will try this and let u know. also if in database it shows encrypte data, then try to fetch it by query. It will return the result, as same as inserted.
Regards... Vijay Jain :)
"One thing you can't recycle is wasted time."