Re: [SQL] Differences between bit string constant sintax

2009-09-10 Thread Jasen Betts
On 2009-09-09, Oliveiros C, wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_013B_01CA3146.85B62920 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Dear All, > > I have a table which has a field that is of typ

[SQL] Differences between bit string constant sintax

2009-09-09 Thread Oliveiros C,
Dear All, I have a table which has a field that is of type bit varying. When I do a direct INSERT with , say, X'1F', everything works fine. But in this table I have to insert several tens of thousands of records each time, so I decided to use COPY command. And if I build a file like this (colum