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 |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2013-12-05 : 06:35:11
|
| when iam trying to load xml data into table i got the below error message"XML parsing: line 48339, character 145, illegal xml character"please let me know what is this error and when it will come |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-12-05 : 06:49:34
|
Your XML document contains an illegal character on line 48339 and character 145.It's probably an ASCII character less than SPACE.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-12-05 : 07:01:28
|
| <RequestRemarks>Request yeild between 0.5 to 1 gram of purified mAb.aandlt;br /aandgt; Production and purification of rat IgG1 mAb, R4-6A2 (ATCC? HB-170???) suitable for in vivo studies.aandamp;nbsp;sterile, no preservative, preferably low endotoxin levels.aandlt;br /aandgt;this is the line i am getting error,please let me know the illegal character which is causing to fail |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-12-05 : 07:41:32
|
| can you please give the list of illegal characters |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-12-06 : 04:48:40
|
The "gt;" will be illegal if you turn on TYPE directive. Since I have absolutely no idea of how you are working with your data, there is nothing I can do at the moment.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-12-06 : 05:01:47
|
| thank for your information. |
|
|
|
|
|
|
|
|
xml parsing