SQL Server config
-
Hello, I am developping ASP.NET 2008. My data is stored in SQL server 2008. The problem is when I query, I got 0 records and this is because the data is stored in hebrew. I tried to change the collation property in Column of the table but it doesn't help Please help
Shay Noy
-
Hello, I am developping ASP.NET 2008. My data is stored in SQL server 2008. The problem is when I query, I got 0 records and this is because the data is stored in hebrew. I tried to change the collation property in Column of the table but it doesn't help Please help
Shay Noy
-
Hello, I am developping ASP.NET 2008. My data is stored in SQL server 2008. The problem is when I query, I got 0 records and this is because the data is stored in hebrew. I tried to change the collation property in Column of the table but it doesn't help Please help
Shay Noy
shaynoy wrote:
The problem is when I query, I got 0 records and this is because the data is stored in hebrew.
How do you know that is the problem? AFAIK, if table has records, query will return irrespective of the type of data. Are you sure the table has records? What data type are you using for keeping values?
Navaneeth How to use google | Ask smart questions
-
Hi--can you post your code so we can see if it might be something with that?
Back in the blog beatch! http://CraptasticNation.blogspot.com/[^]
Private Function GetPathPicturesFromDb(ByVal Period As String, ByVal Location As String) As String Dim ds As New DataSet("Pictures") Dim strSQL As String = "SELECT FullFileName FROM PicturesTable " & _ "WHERE PERIOD='" & Period & "' " & _ "AND LOCATION='" & Location & "'" Dim sqlConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("MemberShipConnectionString").ConnectionString) sqlConnection.Open() Dim da As New SqlDataAdapter() da.SelectCommand = New SqlCommand(strSQL, sqlConnection) da.Fill(ds) If ds.Tables(0).Rows.Count > 0 Then _ Return ds.Tables(0).DefaultView(0).Row("FullFileName").ToString.Trim Return "" End Function The Location field contains hebrew words and when I am querying by changing the database content in english it works perfectly with the same code I post upstair. So I am sure that the problem is because the hebrew. I need to config anywhere that the Location column can contain hebrew characters. Again, I success to insert hebrew words in the databse but when I am querying no records are found Thanks
Shay Noy
-
shaynoy wrote:
The problem is when I query, I got 0 records and this is because the data is stored in hebrew.
How do you know that is the problem? AFAIK, if table has records, query will return irrespective of the type of data. Are you sure the table has records? What data type are you using for keeping values?
Navaneeth How to use google | Ask smart questions
This is a new table that I insert record in it and yes I am sure there are records and i am sure that my query is OK. I just need to know how to config the column that store hebrew characters to get abiility for query on it
Shay Noy