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 - 2000-11-10 : 13:41:15
|
Igor writes "I am having strange problem in SQL 7.0 and SQL 2000.I have a table with field Entry NVARCHAR(450).This field contains different accented characters.
When I run query
SELECT * FROM [Table] WHERE Entry='ß'
I got two records
EntryID Entry
1 ss
2 ß
I am using SQL_Latin1_General_CP850_CS_AS collation for Entry field.Once I change datatype to VARCHAR everything works fine.Similar problem for NVARCHAR field in SQL 7.0 (SP2).I am using codepage 850 in SQL 7.0.
I appreciate if you could shed some light on this problem.
Igor." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-12-02 : 02:08:47
|
| try using a binary comparison. this will compare the binary representation of the characters...egselect * from [Table] where entry collate Latin1_General_BIN = 'ß'let me know if this doesn't solve the problem--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Problem with letter ß