Special character β saved in db but becomes ß which causing LINQ join issue

[Sudip_inn]

i just notice initially character was β which saved in db and when data fetch from db then β becomes ß

both are different charater. in db the column data type was VARCHAR(MAX) later i changed NVARCHAR(MAX) but still β saved as ß in db which causing main issues.

so please tell me how to save this special char β in db as a result when fetch from db later then char should be β not ß


when doing this below LINQ query then few records is not storing into result

var tickerBrokerStandardDateLineitemValuesGroups = (from tickerBrokerStandardDateLineitemValue in TickerBrokerStandardDateLineitemValues
join _10QK in dt10QKDataFile.AsEnumerable()
on new
{
TabName = tickerBrokerStandardDateLineitemValue.TabName.ToString().Trim().ToUpper(),
StandardLineItem = tickerBrokerStandardDateLineitemValue.StandardLineItem.ToString().Trim().ToUpper()
}
equals new
{
TabName = _10QK.Field<string>("TabName").ToString().Trim().ToUpper(),
StandardLineItem = _10QK.Field<string>("StandardLineItem").ToString().Trim().ToUpper()
}
group tickerBrokerStandardDateLineitemValue by new
{
Section = _10QK.Field<string>("TabName").ToString(),
LineItem = _10QK.Field<string>("StandardLineItem").ToString()
} into tickerBrokerStandardDateLineitemValuesGroup
select tickerBrokerStandardDateLineitemValuesGroup);
please tell me how to save this char β in db in such a way when i will fetch that same data from db then it should not be return as ß rather should be return as β


thanks

Continue reading...