I'm trying to read a UTF8 file that contains a stream of characters. It contains records of 256 characters long. Character ö (C3 B6) takes two bytes and the record is 257 bytes long. This does not go well with my external table definition. The records gets shifted by 1 byte.
According to the documentation: The FIXED clause is used to identify the records as all having a fixed size of length bytes
There is no "end of record" character so I have to go by length.
Is there a way to read this kind of files using external tables or do I have to read it as CLOB and get the records out using substr instr etc.?