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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2004-07-19 : 03:58:30
|
| Hi ,I just exported data from a view to a wordpad and found some records with #130;#130;#130;#130;#130;#130;#130;#130;#130;#130; characters . However they do not appear to be in the database . Could be a problem in the source data or with export options that needs to be set specifically to eliminate these characters . The datatype of the field is varchar with length 80 . Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-19 : 12:56:44
|
| How did you do the export?Tara |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2004-07-19 : 21:14:57
|
| I exported the data through DTS to a text file first and then also tried using BCP specifying the format . Then I opened the txt file through wordpad utility where I found these characters . Thanks |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-19 : 23:01:54
|
| If you can find a row that this is in, try to do a LEN on the row. Then find out what CHAR each space is that's used.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2004-07-19 : 23:41:23
|
| Thanks for your reply . I checked that the rows have some non-ASCII characters in it with the character set information that it returned when I executed the query with ascii and substring functions . Probably this requires a data cleanup . Tks once again. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 08:33:04
|
| You might want to dump to a Unicode file and see if that takes care of it. Just an idea.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Strange characters in Wordpad after export