35 10.3. Cancel events 35 11. Reading row data 36 Appendix A: External Data Representation (XDR) 37 Appendix B: Data types 38 Appendix C: Revision history 39 ### Chapter 1. Introduction This It is not in XDR format Int16 Socket family  This is part of the sockaddr in structure. It is not in XDR format Byte It is not in XDR format Byte[8] Zeroes  This is part of the sockaddr in structure. It is not in XDR format Byte[4]

replace database from backup file Firebird SQL role use services manager transportable backup -- data in XDR format do not reserve space for record versions Firebird user name report each action taken redirect/suppress -OL(D_DESCRIPTIONS) save old style metadata descriptions -T(RANSPORTABLE) transportable backup -- data in XDR format gbak:restore options are: -BU(FFERS) override page buffers default -FIX_FSS_D(ATA) fix malformed transportable. Transportable backup files are written in a format known as external data representation (XDR) format and it is this format which allows a dump taken on a server of one type to be successfully

use a transaction. -E ENDIAN Control endianness of generated binary output of raster; specify 0 for XDR and 1 for NDR (default); only NDR output is supported now -V version Specify version of output format ST_AsBinary(geometry g1); bytea ST_AsBinary(geometry g1, text NDR_or_XDR); bytea ST_AsBinary(geography g1); bytea ST_AsBinary(geography g1, text NDR_or_XDR); ## Description Returns the Well-Known Binary representation a second argument denoting the encoding - using little-endian ('NDR') or big-endian ('XDR') encoding. This is useful in binary cursors to pull data out of the database without converting

ay\_dim|Array dimension for column <string> is invalid| |-901|336330807|gbak\_xdr\_len\_expected|Expected XDR record length| |-901|336330817|gbak\_open\_bkup\_error|Cannot open backup file <string>|

|-901|336330804|gbak\_inv\_array\_dim|Array dimension for column %s is invalid| |-901|336330807|gbak\_xdr\_len\_expected|Expected XDR record length| |-901|335544376|unres\_rel|Table %s was omitted from the transaction reserving

|-901|336330804|gbak\_inv\_array\_dim|Array dimension for column @1 is invalid| |-901|336330807|gbak\_xdr\_len\_expected|Expected XDR record length| |-901|335544376|unres\_rel|Table @1 was omitted from the transaction reserving

use a transaction. -E ENDIAN Control endianness of generated binary output of raster; specify 0 for XDR and 1 for NDR (default); only NDR output is supported now -V version Specify version of output format ST_AsBinary(geometry g1); bytea ST_AsBinary(geometry g1, text NDR_or_XDR); bytea ST_AsBinary(geography g1); bytea ST_AsBinary(geography g1, text NDR_or_XDR); ## Description Returns the Well-Known Binary representation a second argument denoting the encoding - using little-endian ('NDR') or big-endian ('XDR') encoding. This is useful in binary cursors to pull data out of the database without converting

ST_AsBinary(geometry g1); bytea ST_AsBinary(geometry g1, text NDR_or_XDR); bytea ST_AsBinary(geography g1); bytea ST_AsBinary(geography g1, text NDR_or_XDR); ## Description Returns the OGC/ISO Well-Known Binary takes a text argument specifying the endian encoding: either 'NDR' for little-endian; or 'XDR' for big-endian. Supplying unknown arguments will result in little-endian output. WKB format is 0 ```sql SELECT ST_AsBinary(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326), 'XDR'); st_asbinary ------------------------------------ \x000000000300000010000000500000000

ST_AsBinary(geometry g1); bytea ST_AsBinary(geometry g1, text NDR_or_XDR); bytea ST_AsBinary(geography g1); bytea ST_AsBinary(geography g1, text NDR_or_XDR); ## X X Returns the OGC/ISO Well-Known Binary (WKB) representation takes a text argument specifying the endian encoding: either 'NDR' for little-endian; or 'XDR' for big-endian. Supplying unknown arguments will result in little-endian output. WKB format is SRID meta data. ## Synopsis bytea ST_AsEWKB(geometry g1); bytea ST_AsEWKB(geometry g1, text NDR_or_XDR); ## --- Returns the Extended Well-Known Binary (EWKB) representation of the geometry with SRID metadata

ST_AsBinary(geometry g1); bytea ST_AsBinary(geometry g1, text NDR_or_XDR); bytea ST_AsBinary(geography g1); bytea ST_AsBinary(geography g1, text NDR_or_XDR); ## Description Returns the OGC/ISO Well-Known Binary argument specifying the endian encoding, either little-endian ('NDR') or big-endian ('XDR'). WKB format is useful to read geometry data from the database and maintaining full numeric precision SRID meta data. ## Synopsis bytea ST_AsEWKB(geometry g1); bytea ST_AsEWKB(geometry g1, text NDR_or_XDR); ## Description Returns the Extended Well-Known Binary (EWKB) representation of the geometry with