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 |
|
floker
Starting Member
6 Posts |
 Posted - 2009-12-03 : 06:43:51
|
| Hi all,I hope someone can help me with this problem. For my work I'm using a SQL 2000 server. To add members into the database we use a website which communicates with the server via a webservice. So let's say I fill in the form on the website, this will call a webservice which will parse the given URL into the database. The issue that I have is that some special characters are not recognized and also not parsed into the database. For example:https://websitename&firstname=J%FCrg&lastname=K%E4zer&Street=...As you can see the firstname should be Jürg but the ü is replaced by %FC and the lastname should be Käzer but the ä is replaced by %E4So in the database I get Jrg and Kzer.Anyone an idea on how to solve this?Thank you all! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-12-03 : 10:31:32
|
| Looks like you are using the wrong codepage or characterset somewhere along the way.Work from your frontend and look to see where the translation/drop of data is occurring.Test outputting to unicode files and you may be able to see where the config (or session info) change needs to be applied.Others have more experience than me in this regard...try member Peso... he should be facing this isue quite a lot, based on his location. |
 |
|
|
|
|
|
Special characters