[
https://issues.jboss.org/browse/TEIID-4340?page=com.atlassian.jira.plugin...
]
Tom Johnston commented on TEIID-4340:
-------------------------------------
I can retrieve the file by negating the BOM characters by doing this:
select replace(convert(a.file,string),'','')
from (EXEC Model.getTextFiles('file.csv')) as a
as a workaround but I can't seem to leverage that along with the TEXTTABLE function to
provide a usable query... any other thoughts?
add encoding as "UTF-8-BOM" in the file translator override
property
--------------------------------------------------------------------
Key: TEIID-4340
URL:
https://issues.jboss.org/browse/TEIID-4340
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors
Affects Versions: 8.7.8.6_2
Reporter: Debbie Steigner
Priority: Trivial
Fix For: Open To Community
it will be good if teiid supports Encoding to "UTF-8-BOM" since other
middleware technologies supports similar to this and also even editor such as Notepad++
supports to convert / save file as "UTF-8-BOM".
Currently we have added Translator override for File to include "Encoding Property
to UTF-8" so similarly we should be able to set it to "UTF-8-BOM" , instead
of writing code manually to add BOM to generate a file.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)