SSDN - funny character output by xslt

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Tim Heap

Subject: funny character output by xslt
Author: Tim Heap
Date: 15 Mar 2007 09:47 AM

Please help.
I have a problem with an xslt file. I'm converting from xml to load in to sql using bulk load. The file which is output is output.txt. If I try bcp, I get "string data, right truncation". Additionally if I run bcp with an error file I get this :
#@ Row 1, Column 1: String data, right truncation @#
KG
If I edit the output file in textpad, add a space and the delete it, then save, the file loads ok.
This is driving me nuts, is it something to do with the encoding ?
The output file is attached.

output(1).txt
pipe delimited output file

(Deleted User)

Subject: funny character output by xslt
Author: (Deleted User)
Date: 15 Mar 2007 11:40 AM

Hi Tim,
could you give us more informations? Are you using Convert-to-XML to convert the file into XML? If the invalid char is produced by an XSLT, could you attach the XSLT file?

Thanks,
Alberto

Tony Lavinio

Subject: funny character output by xslt
Author: Tony Lavinio
Date: 19 Mar 2007 11:08 AM

It looks like an encoding problem; probably bcp is expecting
iso-8859-1 but you are giving it utf-8.

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.