-
1. Re: postgresql translator - remove all nulls & non printable characters from text?
shawkins Oct 14, 2016 8:27 AM (in response to omarbkhan)> Postgres error on insert - ERROR: invalid byte sequence for encoding “UTF8”: 0x00
That's a fundamental limitation of PostgreSQL, which would be expected in this case.
> at this point can only remove nulls. I did also try the following pattern - but it didn't work:
\p{C}
Can you elaborate, how did you try that pattern?
Do you mean in the regexp_replace function on Teiid 8.11+? One consideration there is that regexp_replace won't be pushed down.
> I was wondering, perhaps if something could be added to the translator strip all non-printable characters ?
You could log an enhancement to for that, but at least for postgresql it does support the other ISO control characters.
-
2. Re: postgresql translator - remove all nulls & non printable characters from text?
omarbkhan Oct 14, 2016 9:17 AM (in response to shawkins)I haven't tried REGEXP_REPLACE, but will next. I'm not clear on the meaning of pushed down, and I should be. Does it mean it won't be sent as native sql to the source system. I'm not understanding the context ?
Where/how I log an enhancement request? to have this added?
-
3. Re: postgresql translator - remove all nulls & non printable characters from text?
shawkins Oct 14, 2016 9:24 AM (in response to omarbkhan)> Does it mean it won't be sent as native sql to the source system. I'm not understanding the context ?
Yes, currently regexp_replace is only evaluated in the Teiid engine.
> Where/how I log an enhancement request? to have this added?
You should use the project JIRA - Teiid - JBoss Issue Tracker