Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-08 : 12:02:30
|
abdalla writes "i have a database sqlserver and the data is updated from anthor database every one min and the adata in the data base is in unicode formate i make
ODBC connection and put the perform the data translation for charchter data not checked but wile i search in the data base with full text
it does not return any data (remaker after i make the chacng the data from text to unicode the same sql qury return value ) plz let me know what i can do in My sqlsever to have result with search
the qurry is
Select news_ent.NEW_id,new_TITLE,new_summary,new_mainsub_rel.subject_id From NEWS_ENT,new_mainsub_rel WHERE news_ent.NEW_CONTENT Like('%Çá%') and news_ent.new_id <= (select max(new_id)from news_ent) and news_ent.new_id >= (select (max(new_id)-500)from news_ent) and news_ent.new_id=new_mainsub_rel.new_id order by new_mainsub_rel.subject_id desc
thank you" |
|
|
|
|
|
i want to search in uincode