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 |
|
Jeff Moden
Aged Yak Warrior
652 Posts |
 Posted - 2008-02-05 : 13:30:24
|
| I've lost my mind...I have data in a file that looks like this...RÍO GRANDEWhen I import it into a table using Bulk Insert, it comes out looking like this...R-O GRANDEI've tried different code page collations (SQL_AltDiction_CP850_CI_AI and SQL_Latin1_General_CP850_CI_AI) but no luck...What am I doing wrong? --Jeff Moden |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2008-02-05 : 14:10:15
|
| Never mind... using a code page of "RAW" on the Bulk Insert command did the trick. Thanks anyway, folks.--Jeff Moden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-05 : 14:21:47
|
What should I now do with my test case? 
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2008-02-05 : 14:50:14
|
| Heh... yeah... I know... kinda "RAW" thing to do to a test case...--Jeff Moden |
|
|
|
|
|
|
Need some help with accent marks, please.