Compression of large databases was impossible to achieve.
The $cfg['CompressOnFly'] parameter (set to TRUE by default) was added to
generate (for gzip and bzip2 formats) a compressed file containing more headers.
Now, the transmission starts almost immediately. The file is sent in smaller chunks
so that the whole process consumes much less memory.
??? ???
???
Chapter 7
[ 125 ]
Choice of Character Set
Chapter 17 of this book will cover the subject of character sets in more detail.
However, it's appropriate at this point to explain a little known feature??”the
possibility of choosing the exact character set for our exported file.
This feature is activated by setting $cfg['AllowAnywhereRecoding'] to TRUE. We
can see here the effect on the interface:
CSV
This format is understood by a lot of programs, and you may find it useful for
exchanging data. Note that it is a data-only format??”there is no SQL structure here.
The available options are:
Fields terminated by: We put a comma here, which means that a comma will
be placed after each field.
Fields enclosed by: We place an enclosing character here (like the quote) to
ensure that a field containing the terminating character (comma) is not taken
for two fields.
??? ???
Exporting Structure and Data
[ 126 ]
Fields escaped by: If the export generator finds the Fields enclosed by
character inside a field, the Fields escaped by character will be placed before
it in order to protect it.
Pages:
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135