Retrieving UNICODE data
-
I have a column in SQL Server with ‘nvarchar’ data type; I entered some string in Sanskrit language from enterprise manager of SQL Server. But when ever I search for that string through C# SQL command, it’s not finding. Record set containing null data. My C# SQL Command is like this... "SELECT SlNo FROM Noun where Word = '"+textBox1.Text+"'"; Same command is able to search English string from the same column. I hope U understood my problem. Can anybody please help me? Thanks in Advance Cheers Shiva
-
I have a column in SQL Server with ‘nvarchar’ data type; I entered some string in Sanskrit language from enterprise manager of SQL Server. But when ever I search for that string through C# SQL command, it’s not finding. Record set containing null data. My C# SQL Command is like this... "SELECT SlNo FROM Noun where Word = '"+textBox1.Text+"'"; Same command is able to search English string from the same column. I hope U understood my problem. Can anybody please help me? Thanks in Advance Cheers Shiva
I don't know if this will help your current problem, but it is something you should do as a matter of habit. That is to use parameterised queries. SQL Injection Attacks and Tips on how to Prevent them[^]. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
-
I have a column in SQL Server with ‘nvarchar’ data type; I entered some string in Sanskrit language from enterprise manager of SQL Server. But when ever I search for that string through C# SQL command, it’s not finding. Record set containing null data. My C# SQL Command is like this... "SELECT SlNo FROM Noun where Word = '"+textBox1.Text+"'"; Same command is able to search English string from the same column. I hope U understood my problem. Can anybody please help me? Thanks in Advance Cheers Shiva
when some unicode characters (like sanskrit , chinese) are entered into DB , they are encoded in sense that a character in sanskrti is converted to say "&55;" & then it is stored in db . Divya Rathi