Yes there could be depending on what you do with it. The (LONG)BYTE data
will be treated as raw but (LONG) VARCHAR type will be subject to
character set handling which could be dealing with  multi-byte
characters. As such, I'd expect BYTE to be more efficient for your
intended purpose.
Regards,
Ian

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of
William
Sent: 17 July 2008 11:30
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] Long varchar vs Long byte

Hi,  Is there any practical difference between a 'long varchar' column
compared to a 'long byte' column field?

Long varchar seems to accept binary data without problem.    We are just

storing and then retriving the data,  the column will not appear in any
where clauses etc.

Thanks.

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres