Re: Need to use a rare field separator in *.dat files

On Mar 11, 4:01 am, "Ramon F Herrera" <r..._at_conexus.net> wrote:
> All my *.dat files are created programmatically and therefore I can
> insert any ASCII character as a field separator. I have used
> characters such as ':' or '|' to mark the border between the fields,
> but needless to say, the data may contain those characters.
>
> What I would like to do is to use some rare (but visible) high ASCII
> value which will be essentially impossible to be present in the raw
> datafiles.
>
> Is that the right approach (in some cases I cannot switch to fixed
> length records)?
>
> How do I define such character in the *.ctl files?
>
> This is what I have now:
>
> FIELDS TERMINATED BY "|"
>
> TIA,
>
> -Ramon F Herrera

I use unvisible character to sperator the fields.

For example: 0x07 (Bell) as column seperator, 0x06 (Ack) as row seperator.

AnySQL