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 |
|
gebru
Starting Member
3 Posts |
 Posted - 2008-03-20 : 03:54:48
|
| SELECT * from tableeMass where Name=N'???'In the above select statement in microsoft SQL server 2005 ,I only want to select all the rows whose name is '???' a Gee'z string(Gee'z is set of Ethiopian characters) it is a unicode string(???=gebru in english,the reason why it is question mark is the characters are gee'z).When we execute the select statement, it brings all the rows instead of the rows whose name is '???'. why? the data type of column Name is nvarchar(50).would you please help me in tackling the problem.please reply me soon,I really need it badly soon for my project of Localized database development. thanks inadvance.gebru |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2008-03-20 : 05:03:00
|
| From what you have posted I think it should work properly.Please post more info on what exactly your data is. |
 |
|
|
gebru
Starting Member
3 Posts |
Posted - 2008-03-20 : 12:13:55
|
| thank you ayamas for replying me . I too,hope that it will work correctly.But to give you the precise info of my table,it is as follows.I have a table named 'tableeMass'.It has only two columns named Id (Int data type) and Name(nvarchar(50) data type).for each row I have supplied a value in Gee'z the the ethiopic script(Gee'z is set of Ethiopic characters).when I make the select statement,SELECT * from tableeMass where Name=N'???',it brings the whole row.the reason why it is question mark is the characters are gee'z. does it make any sense now.please reply me soon,I really need it badly soon for my project of Localized database development. thank you again. |
|
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2008-03-21 : 06:46:50
|
| I cannot understand this.You are saying that the actual Gee'z characters are '???'If not then please post the actual characters but if it is '???' then for me it is working.declare @tbl table(name nvarchar(50))insert into @tblselect '???'union allselect 'abc'select * from @tbl where name=N'???'Also try to set proper collation. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-03-21 : 07:58:38
|
| I think what he's saying is that the ??? stands for Ge'ez script that can't be translated onto a web page. I did a little research on Ge'ez and found this articlehttp://www.ethiopiaknowledge.org/Final%20Papers/Localised%20Applications,%20Gebreselassie.PDFGebre It looks like the problem may not be the Unicode, but the operating system that you are using.I'm sorry I don't have a solution for you, but I hope this helpsJim |
|
|
|
gebru
Starting Member
3 Posts |
Posted - 2008-03-21 : 11:54:21
|
| thank you both ayamas and jimf for replying me inadvance.Yet the problem remains unsolved.ayamas I tried to set the proper collation,but does the Gee'z script(Ethiopia) has collation.that is also one of my question.jimf is right the Ge'ez script can't be translated onto a web page that is why you are not able to read the exact characters.jimf I read that link(thank you for that) many times but it couldn't help me. sql server 2005 supports unicode characters,it has nothing to do with the operating system.please reply me soon,I really need it badly soon for my project of Localized database development. thank you again. |
|
|
|
|
|
|
|
|
unicode(Gee'z) strings in the WHERE sql statement