[teiid-issues] [JBoss JIRA] (TEIID-4340) add encoding as "UTF-8-BOM" in the file translator override property

[Tom Johnston (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13622783#comment-13622783 ] 

Tom Johnston commented on TEIID-4340:
-------------------------------------

[~shawkins] Wondering why this is not needed?
I have csv files that are encoded as such but TO_CHARS(a.file, 'UTF-8-BOM')  returns as TEIID30492 Encoding 'UTF-8-BOM' is not valid
Is there some other workaround?

> 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)