 |
ActiveDelphi
.: O site do programador Delphi! :.
|
| Exibir mensagem anterior :: Exibir próxima mensagem |
| Autor |
Mensagem |
adriano_servitec
Colaborador
Registrado: Sexta-Feira, 30 de Janeiro de 2004
Mensagens: 17618
|
 Enviada: Ter Nov 07, 2017 10:18 am Assunto: Problema com convert do sql server 2014? |
 |
|
Tenho este query para converter aquivo image do sql server em xml.
| Código: | SELECT
codigo,
Blob_Arquivo,
CONVERT(xml, CONVERT(nvarchar(max), CONVERT(varbinary(max), Blob_Arquivo)))
FROM
dbo.Arquivo_Blob
where
Codigo = 8392850 |
Funciona na maioria mais tem alguns que da erro, tipo
Msg 9402, Level 16, State 1, Line 10
XML parsing: line 1, character 39, unable to switch the encoding
Este é o xml que estou tentando converter de image para xml
| Citação: | <?xml version="1.0" encoding="UTF-8" ?><nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe41160100584537000146550010000097451083903657" versao="3.10"><ide><cUF>41</cUF><cNF>08390365</cNF><natOp>Saida de mercadoria</natOp><indPag>2</indPag><mod>55</mod><serie>1</serie><nNF>9745</nNF><dhEmi>2016-01-21T12:57:06-02:00</dhEmi><dhSaiEnt>2016-01-21T12:57:06-02:00</dhSaiEnt><tpNF>1</tpNF><idDest>1</idDest><cMunFG>4106902</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>2</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>2</indPres><procEmi>0</procEmi><verProc>2.6.24.494</verProc></ide><emit><CNPJ>00584537000146</CNPJ><xNome>Think servicos de Informatica ltda</xNome><enderEmit><xLgr>Teste</xLgr><nro>26</nro><xBairro>PARQUE CASTELANDIA II</xBairro><cMun>4106902</cMun><xMun>Curitiba</xMun><UF>PR</UF><CEP>80440220</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6634985029</fone></enderEmit><IE>1000685085</IE><CRT>1</CRT></emit><dest><CNPJ>99999999000191</CNPJ><xNome>NF-E EMITIDA EM AMBIENTE DE HOMOLOGACAO - SEM VALOR FISCAL</xNome><enderDest><xLgr>Rua Oliveira Vianao</xLgr><nro>114</nro><xBairro>Hauer</xBairro><cMun>4106902</cMun><xMun>Curitiba</xMun><UF>PR</UF><CEP>81630070</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>00000000000</fone></enderDest><indIEDest>2</indIEDest></dest><det nItem="1"><prod><cProd>400001</cProd><cEAN/><xProd>PORTEIRO ELETRONICO P-10 ABS/ALUM PEQ - SMD AGL</xProd><NCM>10011100</NCM><CEST>1100100</CEST><CFOP>5949</CFOP><uCom>UN</uCom><qCom>1.0000</qCom><vUnCom>61.8600000000</vUnCom><vProd>61.86</vProd><cEANTrib/><uTrib>UN</uTrib><qTrib>1.0000</qTrib><vUnTrib>61.8600000000</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>2.59</vTotTrib><ICMS><ICMSSN500><orig>0</orig><CSOSN>500</CSOSN><vBCSTRet>0.00</vBCSTRet><vICMSSTRet>0.00</vICMSSTRet></ICMSSN500></ICMS><IPI><clEnq>999</clEnq><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISOutr><CST>49</CST><vBC>61.86</vBC><pPIS>0.00</pPIS><vPIS>0.00</vPIS></PISOutr></PIS><COFINS><COFINSOutr><CST>49</CST><vBC>61.86</vBC><pCOFINS>0.00</pCOFINS><vCOFINS>0.00</vCOFINS></COFINSOutr></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>61.86</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>61.86</vNF><vTotTrib>2.59</vTotTrib></ICMSTot></total><transp><modFrete>1</modFrete></transp></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe41160100584537000146550010000097451083903657"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315"/></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><DigestValue>w0yWTvQollYs3o5YEv/DyGOLd1E=</DigestValue></Reference></SignedInfo><SignatureValue>G2mhTEOy77pKcURO9zZJ06JfwyW1m3+ua6Gq/TwLRRlijWIdQ++xxL5VazaNUGI3rxTYwIl7vH5FL6eoAOGms8A/nh1Wm603SR7VkZcS+XV/4h/T8qSNnQrcIPLmjOBlQRfQNKSuKZdnzYU6/Ue27826LEmYc11eZErajDNOqOecHrZyE0FuqQJnsJCGk6FPMJWqvvcdjFgdwGzv48F6tiX5G0lDnn7ieAsai/EDZr+IM8osmKREVrplaTtyTR5MLpXbCldUW0UOLmoKCNzRrxU/siOhB2F3RbSXO3mzwdR6T8KzQ1tEd9F9W7AtAh/kF2nJ0cy9agawfiycDdvu9w==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIIWDCCBkCgAwIBAgIQJ79jm4j9zBjXvPvlet1m4zANBgkqhkiG9w0BAQsFADB0MQswCQYDVQQGEwJCUjETMBEGA1UEChMKSUNQLUJyYXNpbDEtMCsGA1UECxMkQ2VydGlzaWduIENlcnRpZmljYWRvcmEgRGlnaXRhbCBTLkEuMSEwHwYDVQQDExhBQyBDZXJ0aXNpZ24gTXVsdGlwbGEgRzUwHhcNMTUxMTA5MDAwMDAwWhcNMTYxMTA3MjM1OTU5WjCB3jELMAkGA1UEBhMCQlIxEzARBgNVBAoUCklDUC1CcmFzaWwxIjAgBgNVBAsUGUF1dGVudGljYWRvIHBvciBBUiBDTkIgQ0YxGzAZBgNVBAsUEkFzc2luYXR1cmEgVGlwbyBBMTEVMBMGA1UECxQMSUQgLSA5NDYwMjgyMS8wLQYDVQQDEyZUSElOSyBTRVJWSUNPUyBERSBJTkZPUk1BVElDQSBMVERBIEVQUDExMC8GCSqGSIb3DQEJARYiYWRtaW5pc3RyYXRpdm9Abm94YXV0b21hY2FvLmNvbS5icjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAISlrBmWhC0G9nGJAAz5aeYQRuMYFrY06rejqjGIdcxe+xNsk+AwEIkcVpWkhQ1GhXe7E8C6wTpi4HmYS+HppeqDwLD08VxkF3k0bn+S80hmrgIvlbIJb4itBj1iLRXzfXxYRIfxEgxJT5pAyl5eWYwlu5V7l+Wz7DLEaWW9gWor7iEf/AXhXsdm1WScFy3L7rDwpYxUP80kg/dZj5AzuabvXV9yeXNRzGM1Dm5CViWYlKchYliSFzMUYfbA2CpjjHm38DEKFcfvJR3Rr9W/JYXNeNlKSGdkptKB+xlehbhzJUh78zt+WZcEvde9tqKcCkr5yMXq0TNJuC/IakQJOy0CAwEAAaOCA3kwggN1MIG/BgNVHREEgbcwgbSgPgYFYEwBAwSgNQQzMjAwOTE5NzM4NzYxODY4MDk0OTAwMDAwMDAwMDAwMDAwMDAwMDU3MTg1MDMxU0VTUFBSoBoGBWBMAQMCoBEED0FDWVIgTFVJWiBBTlRVTqAZBgVgTAEDA6AQBA4wMDU4NDUzNzAwMDE0NqAXBgVgTAEDB6AOBAwwMDAwMDAwMDAwMDCBImFkbWluaXN0cmF0aXZvQG5veGF1dG9tYWNhby5jb20uYnIwCQYDVR0TBAIwADAfBgNVHSMEGDAWgBSdUM+9/yTKr7Ez6xfiQnqOaSqOUzAOBgNVHQ8BAf8EBAMCBeAwgYkGA1UdIASBgTB/MH0GBmBMAQIBCzBzMHEGCCsGAQUFBwIBFmVodHRwOi8vaWNwLWJyYXNpbC5jZXJ0aXNpZ24uY29tLmJyL3JlcG9zaXRvcmlvL2RwYy9BQ19DZXJ0aXNpZ25fTXVsdGlwbGEvRFBDX0FDX0NlcnRpU2lnbk11bHRpcGxhLnBkZjCCASUGA1UdHwSCARwwggEYMFygWqBYhlZodHRwOi8vaWNwLWJyYXNpbC5jZXJ0aXNpZ24uY29tLmJyL3JlcG9zaXRvcmlvL2xjci9BQ0NlcnRpc2lnbk11bHRpcGxhRzUvTGF0ZXN0Q1JMLmNybDBboFmgV4ZVaHR0cDovL2ljcC1icmFzaWwub3V0cmFsY3IuY29tLmJyL3JlcG9zaXRvcmlvL2xjci9BQ0NlcnRpc2lnbk11bHRpcGxhRzUvTGF0ZXN0Q1JMLmNybDBboFmgV4ZVaHR0cDovL3JlcG9zaXRvcmlvLmljcGJyYXNpbC5nb3YuYnIvbGNyL0NlcnRpc2lnbi9BQ0NlcnRpc2lnbk11bHRpcGxhRzUvTGF0ZXN0Q1JMLmNybDAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwgaAGCCsGAQUFBwEBBIGTMIGQMGQGCCsGAQUFBzAChlhodHRwOi8vaWNwLWJyYXNpbC5jZXJ0aXNpZ24uY29tLmJyL3JlcG9zaXRvcmlvL2NlcnRpZmljYWRvcy9BQ19DZXJ0aXNpZ25fTXVsdGlwbGFfRzUucDdjMCgGCCsGAQUFBzABhhxodHRwOi8vb2NzcC5jZXJ0aXNpZ24uY29tLmJyMA0GCSqGSIb3DQEBCwUAA4ICAQCyRwW3VpounCvwvTL4CH6ugdD2KtbBFyH1TfUmDibWEevmx53H3fac90EE8r/SAmh9q/kn937Cfqf1s/sNpLzxufca7qjQlZxEelh4EopGCsi59gGnYysLlp8dcrY83BoaPELU+1COyvxdktJmvZjSO6mP+XVKNEHVxxpZ97kdCr/aCHH3tabGgXuNmsc6ckSNBr4hI6Lz/W+YDEoSxWs6KS6l6GVapWmBaM1nbFhbls7GUgF3vLqpIJTFfTeTK8ZhFPxD/kd61A7wARPPxqiYOmPuMCE4KWQLs9kUOa1SgEv9N/uyocSlxaxgEyFwPFANi+/SVfkXwrmqzDDTvF7/h+lvyr2RIMcgtjOTkjIhp0q1fYfb4GD1Ea3tVOkZo6zjHYX+w418vt64d5SBxMdnwaLUBOEHqwquZLujybkQMxOhmQbY8IFMmwyBJrF5e70qSICtKAiM5zsFvQMNz1ApyDUOKTYJSARTl3CUzXpwEv3itJgYOiXVgvVEDne/f+8mCc8kJtPKApuPboj+xSK8NcQ369GBs35SqCcCF4ElmhZ4Az20U4ZkVrl/apXq2nD6HlWhOgst9+OnDCenIwEL/CB46tXTjHEM0aQKRBqD5qQH1flP16iw9RUbLVCIAIf3cCZbcMuYrUl0RJovfrFqd+EdvA4sHcu7s0/fapCY6g==</X509Certificate></X509Data></KeyInfo></Signature></NFe>
<protNFe xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10"><infProt><tpAmb>2</tpAmb><verAplic>PR-v3_5_1</verAplic><chNFe>41160100584537000146550010000097451083903657</chNFe><dhRecbto>2016-01-21T12:53:20-02:00</dhRecbto><nProt>141160000041973</nProt><digVal>w0yWTvQollYs3o5YEv/DyGOLd1E=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc>
|
_________________
Jogo seu smartphone? Acesse o link e confira.
https://play.google.com/store/apps/details?id=br.com.couldsys.rockdrum
https://play.google.com/store/apps/details?id=br.com.couldsys.drumsetfree |
|
| Voltar ao Topo |
|
 |
adriano_servitec
Colaborador
Registrado: Sexta-Feira, 30 de Janeiro de 2004
Mensagens: 17618
|
| Enviada: Qua Nov 08, 2017 10:00 am Assunto: |
|
|
Resolvi o problema usando o replace
segue pra quem precisar
| Código: | declare @xmlOut nvarchar(max)
SELECT
@xmlout = CONVERT(nvarchar(max), CONVERT(varbinary(max), Blob_Arquivo))
FROM
dbo.Arquivo_Blob
where
Codigo = 8392850
/* Trata os caracteres especiais */
Set @xmlOut = REPLACE(@xmlOut, '>', '>')
Set @xmlOut = REPLACE(@xmlOut, '<', '<')
--Set @xmlOut = REPLACE(@xmlOut, 'çã', 'ca')
Set @xmlOut = REPLACE(@xmlOut, 'UTF-8', 'UTF-16')
select convert(xml, @xmlout) |
_________________
Jogo seu smartphone? Acesse o link e confira.
https://play.google.com/store/apps/details?id=br.com.couldsys.rockdrum
https://play.google.com/store/apps/details?id=br.com.couldsys.drumsetfree |
|
| Voltar ao Topo |
|
|
|
|
Enviar Mensagens Novas: Proibido.
Responder Tópicos Proibido
Editar Mensagens: Proibido.
Excluir Mensagens: Proibido.
Votar em Enquetes: Proibido.
|
|
FAQ
Pesquisar
Membros
Grupos
Registrar
Perfil
Entrar e ver Mensagens Particulares
Entrar
