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 |
|
olibara
Yak Posting Veteran
94 Posts |
 Posted - 2012-11-10 : 13:55:59
|
HelloIn some DB a table was imported but some field defined as nvarchar contains bad accentuated charExemple :quote:
Elzeelsesteenweg;Chaussée d'Ellezelles;N57
It must be in fact 'é' but not 'é'Do somebody already encounter this experience and knows a generic way to fix all those 'wrong' converted char ?Thank for your helpMerci de votre aide |
|
|
olibara
Yak Posting Veteran
94 Posts |
Posted - 2012-11-11 : 17:12:01
|
| Hello The only way I found for now is to make a set of update with tricky replacement asREPLACE(streetName,'é','é')But I've first to find out ALL those UTF8 to replaceStill no better solution ? |
 |
|
|
|
|
|
Wrong character conversion