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 |
|
purushottamshete
Starting Member
2 Posts |
 Posted - 2007-11-19 : 02:19:24
|
| Hi,SQL> select MB_FIRST,MB_LAST from member where MB_LAST like '%æøåÆØ%';MB_FIRST MB_LAST------------------------------ ------------------------------Bjødstrup æøåÆØÅabcBjødstrup æøåÆØÅABCSQL> select LOWER(MB_FIRST),LOWER(MB_LAST) from member where MB_LAST like '%æøåÆØ%';LOWER(MB_FIRST) LOWER(MB_LAST)------------------------------ ------------------------------bjxdstrup fxefxeabcbjxdstrup fxefxeabcWHY LOWER FUNCTION WROKING LIKE THIS ?????? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-19 : 07:47:02
|
Are you using a CasE SEnsITive COllAtIOn?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-11-19 : 12:07:53
|
Only Danish character I know of is Peso (Sweeds are Danes, right?  )[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
purushottamshete
Starting Member
2 Posts |
Posted - 2007-11-20 : 00:16:03
|
quote:
Originally posted by Peso
Are you using a CasE SEnsITive COllAtIOn?
E 12�55'05.25"N 56�04'39.16"
yes |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-11-20 : 13:15:08
|
quote:
Originally posted by DonAtWork
Only Danish character I know of is Peso (Sweeds are Danes, right? )
Don't know about the Swedes/Danes thing, but I agree that Peso is a character.  |
|
|
|
|
|
|
PROBLEM WITH DANISH CHARECHTERS