Received: from smartr.hksmartone.com ([202.73.249.54]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA57805 for ; Sun, 9 Apr 2000 23:42:10 -0400 (EDT) (envelope-from sam_ma@hksmartone.com) From: sam_ma@hksmartone.com Received: from localhost (root@localhost) by smartr.hksmartone.com (8.8.6 (PHNE_14041)/8.8.6) with SMTP id LAA17908 for pgsql-sql@postgresql.org; Mon, 10 Apr 2000 11:43:46 +0800 (EAT) X-OpenMail-Hops: 1 Date: Mon, 10 Apr 2000 11:43:38 +0800 Message-Id: Subject: Question on the datatype binary MIME-Version: 1.0 TO: pgsql-sql@postgresql.org Content-Type: multipart/mixed; boundary="openmail-part-038b67d5-00000001" X-Archive-Number: 200004/87 --openmail-part-038b67d5-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit Dear Sir/Miss Is it possible to have datatype of binary in postgres's database and what's the syntax to define. I get data which is not fix in ascii which should put it in binary field. Thanks a lot. rgds Sam Ma --openmail-part-038b67d5-00000001 Content-Type: application/ms-tnef; name="WINMAIL.DAT" Content-Disposition: attachment; filename="WINMAIL.DAT" Content-Transfer-Encoding: base64 eJ8+ItTYAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEE gAEAIAAAAFF1ZXN0aW9uIG9uIHRoZSBkYXRhdHlwZSBiaW5hcnkA1wsBBYAD AA4AAADQBwQACgALACcALgABAEYBAQCAAAAwAAAABAAwAAgAGABTYW0gTWEA AE9QRU5NQUlMOlNhbSBNYSAvb20xLERWAAAAAAAAAAAA4wgBIIADAA4AAADQ BwQACgALACMAKwABAD8BAQmAAQAhAAAAMTIxNUU5MDI3RTBFRDQxMThGNEMw MDEwNUE3NDU5OEYA9wYBA5AGANACAAAeAAAACwACAAEAAAALACMAAAAAAAMA JgAAAAAACwApAAAAAAADADYAAAAAAEAAOQCwgpdqnqK/AR4AQgABAAAABwAA AFNhbSBNYQAAQABIACA1EGueor8BHgBwAAEAAAAgAAAAUXVlc3Rpb24gb24g dGhlIGRhdGF0eXBlIGJpbmFyeQACAXEAAQAAABYAAAABv6KeapQC6RUTDn4R 1I9MABBadFmPAAAeABoMAQAAAAcAAABTYW0gTWEAAAIBHQwBAAAAGAAAAE9Q RU5NQUlMOlNBTSBNQSAvT00xLERWAB4AHgwBAAAACQAAAE9QRU5NQUlMAAAA AB4AHwwBAAAADwAAAFNhbSBNYSAvb20xLERWAAADAIAQ/////0AABzCwV67Z naK/AUAACDCwV67ZnaK/AQsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAA AAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAA AADAAAAAAAAARgAAAABShQAA8xUAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAA AFSFAAABAAAABQAAADguMDQAAAAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAA AYUAAAAAAAALAC+ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMIAI IAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAggBgAAAAAAwAAAAAAA AEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAA AAAAAB4AQ4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAe AD0AAQAAAAEAAAAAAAAAAwANNP03AACqXg== --openmail-part-038b67d5-00000001--