Обсуждение: one byte data type
Hi gang, Is there a datatype that means "one byte"? I'm importing a database from SQL Server, and some of the rows there are of this type. When I convert them to int2, I have discrepancies with the program that uses the database (OLE DB uses binary mode transfers, so the size of the variable is important beyond it's legal range). Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/
Shachar Shemesh <psql@shemesh.biz> writes: > Is there a datatype that means "one byte"? You might be able to use the "char" type (note the quotes). I am not sure how well it will cope with storing zeroes (nulls) though. regards, tom lane
Tom Lane wrote: >Shachar Shemesh <psql@shemesh.biz> writes: > > >>Is there a datatype that means "one byte"? >> >> > >You might be able to use the "char" type (note the quotes). I am not >sure how well it will cope with storing zeroes (nulls) though. > > regards, tom lane > > Hmm, this will also screw up textual queries. Not important for this particular case, but not a good general solution. What are the chances of adding such a type for 7.4.2? Shachar P.S. Notice how this message arrives directly as well, despite spam filters. -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/