---
product: Chilkat
product_version: 11.7.0
language: sqlserver
language_label: SQL Server
class: ZipEntry
license: bundle
deprecated: false
reference_html: https://www.chilkatsoft.com/refdoc/sqlserver_ZipEntryRef.html
---
# Chilkat ZipEntry — SQL Server — v11.7.0

> Chilkat 11.7.0 · language=sqlserver · class=ZipEntry
> Other versions: replace `11.7.0` in this URL. Other languages: `https://www.chilkatsoft.com/ai-docs/v/11.7.0/<lang>/classes/ZipEntry.md`.
> Language-wide rules (install, unlock, error model, strings/bytes): `https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/guide.md`.

## Purpose

**Inspect, extract, update, and iterate individual entries inside a ZIP archive.**

`Chilkat.ZipEntry` represents a single item associated with a `Chilkat.Zip` archive. An entry may be a file already stored in an opened ZIP, a referenced filesystem file waiting to be compressed, an in-memory text or binary entry, or a directory entry. It provides access to entry-level metadata, compressed and uncompressed data, timestamps, attributes, CRC values, encryption information, and extraction or replacement operations for that specific ZIP item.

**Entry metadata**

Inspect filenames, stored ZIP paths, comments, timestamps, CRC values, attributes, sizes, compression method, and compression level.

**Entry type and state**

Use `EntryType` to understand whether the entry comes from an existing ZIP, a filesystem reference, memory data, or a directory.

**Extract one entry**

Extract a selected file entry to disk, inflate its contents into memory, or read the uncompressed data into Chilkat objects.

**Read compressed data**

Access the raw compressed entry data when an application needs ZIP-level control rather than only the inflated contents.

**Replace or append data**

Update an entry's contents from strings, byte data, files, or in-memory data sources before writing the ZIP archive.

**Iterate archive entries**

Walk through entries returned from `Chilkat.Zip` methods to inspect, filter, extract, or modify ZIP contents one item at a time.

**Common pattern:** Open or create a `Chilkat.Zip` object, obtain a `ZipEntry` using methods such as `EntryAt`, `EntryOf`, `EntryMatching`, or `FirstEntry`, then inspect metadata, extract contents, update the entry, or continue iterating through the archive. Use `Chilkat.Zip` for whole-archive operations and `ZipEntry` for operations on one specific archive item.

For an extended overview, see [ZipEntry Overview](https://www.chilkatsoft.com/zipEntry_overview.asp).

## Object creation, unlocking and error handling

**Object Creation**

```sql
DECLARE @hr int
DECLARE @zipEntry int
EXEC @hr = sp_OACreate 'Chilkat.ZipEntry', @zipEntry OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @zipEntry ...

EXEC @hr = sp_OADestroy @zipEntry
```

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (`EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;`), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as `sp_OACreate 'Chilkat.ZipEntry.11'` for Chilkat v11.\*.\*.

`sp_OACreate` returns an object token (an `int`) that is passed as the first argument of every `sp_OAMethod`, `sp_OAGetProperty` and `sp_OASetProperty` call, and released with `sp_OADestroy`. Objects returned by methods (such as an `HttpResponse` or `JsonObject`) are also tokens received through an `int` OUT parameter; they must likewise be destroyed, and the OUT parameter is `NULL` when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero `@hr`), `sp_OAGetErrorInfo` describes the error.

Data types: strings are `nvarchar(4000)`; integers, booleans (1 or 0) and object tokens are `int`; dates are `datetime`. In the signatures on this page, `@success`, `@iResult`, `@sResult` and the like are the OUT variables receiving a method's return value, `@iValue` / `@sValue` receive or supply a property value, and the remaining `@` variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example `DECLARE @tmp TABLE (outputLine ntext)` followed by `INSERT INTO @tmp EXEC sp_OAGetProperty @zipEntry, 'LastErrorText'`. See [string length limitations for strings returned by sp_OAMethod calls](https://www.chilkatsoft.com/sql_server_nvarchar_max_limitation.asp).

Methods that pass or return raw byte arrays are not shown on this page, because `varbinary(max)` values cannot be exchanged through `sp_OAMethod` (see [varbinary(max) limitation](https://www.chilkatsoft.com/sql_server_varbinary_max_limitation.asp)). Use the `BinData`-based alternatives (methods ending in *Bd*) or the base64 / hex string-encoded variants instead. Binary *properties* (such as `LastBinaryResult`) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*\*Async*) methods and event callbacks are not available from SQL Server.

Call `Global.UnlockBundle` once at the start of the program, before using this or any other Chilkat class. Any string unlocks a fully functional 30-day trial; a purchased unlock code is used in production. See `guide.md` for the exact code in SQL Server.

How failure is reported depends on the method's return type and is stated in the note under each method below. In every case the diagnostic text is in the `LastErrorText` property of the object whose method was called.

## Members common to every Chilkat class

Documented once per language in `common-members.md`; listed here so this page is self-contained.

| Property | Signature | Access | Meaning |
|---|---|---|---|
| `DebugLogFilePath` | `EXEC sp_OAGetProperty @zipEntry, 'DebugLogFilePath', @sValue OUT EXEC sp_OASetProperty @zipEntry, 'DebugLogFilePath', @sValue` | read/write | If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. |
| `LastBinaryResult` | `INSERT INTO @tmp EXEC sp_OAGetProperty @zipEntry, 'LastBinaryResult'` | read-only | This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. |
| `LastErrorHtml` | `EXEC sp_OAGetProperty @zipEntry, 'LastErrorHtml', @sValue OUT` | read-only | Provides HTML-formatted information about the last called method or property. |
| `LastErrorText` | `EXEC sp_OAGetProperty @zipEntry, 'LastErrorText', @sValue OUT` | read-only | Provides plain text information about the last called method or property. |
| `LastErrorXml` | `EXEC sp_OAGetProperty @zipEntry, 'LastErrorXml', @sValue OUT` | read-only | Provides XML-formatted information about the last called method or property. |
| `LastMethodSuccess` | `EXEC sp_OAGetProperty @zipEntry, 'LastMethodSuccess', @iValue OUT EXEC sp_OASetProperty @zipEntry, 'LastMethodSuccess', @iValue` | read/write | Indicates the success or failure of the most recent method call: `1` means success, `0` means failure. |
| `LastStringResult` | `EXEC sp_OAGetProperty @zipEntry, 'LastStringResult', @sValue OUT` | read-only | In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. |
| `LastStringResultLen` | `EXEC sp_OAGetProperty @zipEntry, 'LastStringResultLen', @iValue OUT` | read-only | The length, in characters, of the string contained in the LastStringResult property. |
| `VerboseLogging` | `EXEC sp_OAGetProperty @zipEntry, 'VerboseLogging', @iValue OUT EXEC sp_OASetProperty @zipEntry, 'VerboseLogging', @iValue` | read/write | If set to `1`, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. |
| `Version` | `EXEC sp_OAGetProperty @zipEntry, 'Version', @sValue OUT` | read-only | Version of the component/library, such as "10.1.0" |

## Member index

| Member | Kind | Signature |
|---|---|---|
| `Comment` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'Comment', @sValue OUT EXEC sp_OASetProperty @zipEntry, 'Comment', @sValue` |
| `CompressedLength` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'CompressedLength', @iValue OUT` |
| `CompressedLengthStr` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'CompressedLengthStr', @sValue OUT` |
| `CompressionLevel` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'CompressionLevel', @iValue OUT EXEC sp_OASetProperty @zipEntry, 'CompressionLevel', @iValue` |
| `CompressionMethod` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'CompressionMethod', @iValue OUT EXEC sp_OASetProperty @zipEntry, 'CompressionMethod', @iValue` |
| `Crc` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'Crc', @iValue OUT` |
| `EncryptionKeyLen` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'EncryptionKeyLen', @iValue OUT` |
| `EntryID` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'EntryID', @iValue OUT` |
| `EntryType` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'EntryType', @iValue OUT` |
| `FileDateTimeStr` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'FileDateTimeStr', @sValue OUT EXEC sp_OASetProperty @zipEntry, 'FileDateTimeStr', @sValue` |
| `FileName` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'FileName', @sValue OUT EXEC sp_OASetProperty @zipEntry, 'FileName', @sValue` |
| `FileNameHex` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'FileNameHex', @sValue OUT` |
| `IsAesEncrypted` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'IsAesEncrypted', @iValue OUT` |
| `IsDirectory` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'IsDirectory', @iValue OUT` |
| `TextFlag` | property, read/write | `EXEC sp_OAGetProperty @zipEntry, 'TextFlag', @iValue OUT EXEC sp_OASetProperty @zipEntry, 'TextFlag', @iValue` |
| `UncompressedLength` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'UncompressedLength', @iValue OUT` |
| `UncompressedLengthStr` | property, read-only | `EXEC sp_OAGetProperty @zipEntry, 'UncompressedLengthStr', @sValue OUT` |
| `AppendString` | method | `EXEC sp_OAMethod @zipEntry, 'AppendString', @success OUT, @strContent, @charset` |
| `CopyToBase64` | method | `EXEC sp_OAMethod @zipEntry, 'CopyToBase64', @sResult OUT` |
| `CopyToHex` | method | `EXEC sp_OAMethod @zipEntry, 'CopyToHex', @sResult OUT` |
| `Extract` | method | `EXEC sp_OAMethod @zipEntry, 'Extract', @success OUT, @dirPath` |
| `ExtractInto` | method | `EXEC sp_OAMethod @zipEntry, 'ExtractInto', @success OUT, @dirPath` |
| `GetNext` | method | `EXEC sp_OAMethod @zipEntry, 'GetNext', @success OUT` |
| `GetNextMatch` | method | `EXEC sp_OAMethod @zipEntry, 'GetNextMatch', @success OUT, @pattern` |
| `ReplaceString` | method | `EXEC sp_OAMethod @zipEntry, 'ReplaceString', @success OUT, @strContent, @charset` |
| `SetDt` | method | `EXEC sp_OAMethod @zipEntry, 'SetDt', NULL, @dt` |
| `UnzipToBd` | method | `EXEC sp_OAMethod @zipEntry, 'UnzipToBd', @success OUT, @binData` |
| `UnzipToSb` | method | `EXEC sp_OAMethod @zipEntry, 'UnzipToSb', @success OUT, @lineEndingBehavior, @srcCharset, @sb` |
| `UnzipToStream` | method | `EXEC sp_OAMethod @zipEntry, 'UnzipToStream', @success OUT, @toStream` |
| `UnzipToString` | method | `EXEC sp_OAMethod @zipEntry, 'UnzipToString', @sResult OUT, @lineEndingBehavior, @srcCharset` |

Deprecated members are listed at the end of this file with their replacements; do not use them in new code.

## Properties

### ZipEntry.Comment

`Chilkat 11.7.0 · sqlserver · ZipEntry · Comment · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'Comment', @sValue OUT
EXEC sp_OASetProperty @zipEntry, 'Comment', @sValue
```

Gets or sets the comment stored in the ZIP archive for this entry.

### ZipEntry.CompressedLength

`Chilkat 11.7.0 · sqlserver · ZipEntry · CompressedLength · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'CompressedLength', @iValue OUT
```

The compressed size of this entry, in bytes.

For mapped entries (entries already contained within an opened ZIP archive), this property contains the actual compressed size stored within the ZIP.

For file entries or data entries that have not yet been written to a ZIP archive, compression has not yet occurred. In these cases, this property contains:

- The current uncompressed data size for data entries.
- The cached filesystem file size for referenced file entries.

After the ZIP archive is written, the entries become mapped entries, and this property then reflects the actual compressed size stored in the ZIP archive.

### ZipEntry.CompressedLengthStr

`Chilkat 11.7.0 · sqlserver · ZipEntry · CompressedLengthStr · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'CompressedLengthStr', @sValue OUT
```

The compressed size of this entry as a decimal string.

For mapped entries (entries already contained within an opened ZIP archive), this property contains the actual compressed size stored within the ZIP.

For file entries or data entries that have not yet been written to a ZIP archive, compression has not yet occurred. In these cases, this property contains:

- The current uncompressed data size for data entries.
- The cached filesystem file size for referenced file entries.

After the ZIP archive is written, the entries become mapped entries, and this property then reflects the actual compressed size stored in the ZIP archive.

This property is useful when sizes may exceed the range of a 32-bit integer.

### ZipEntry.CompressionLevel

`Chilkat 11.7.0 · sqlserver · ZipEntry · CompressionLevel · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'CompressionLevel', @iValue OUT
EXEC sp_OASetProperty @zipEntry, 'CompressionLevel', @iValue
```

Gets or sets the compression level for this entry.

A value of `0` means no compression, and a value of `9` means maximum compression.

The default value is `6`.

### ZipEntry.CompressionMethod

`Chilkat 11.7.0 · sqlserver · ZipEntry · CompressionMethod · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'CompressionMethod', @iValue OUT
EXEC sp_OASetProperty @zipEntry, 'CompressionMethod', @iValue
```

Gets or sets the compression method used for this entry.

- `0` means no compression.
- `8` means Deflate compression.

Deflate is the standard compression algorithm used by common ZIP utilities such as WinZip.

### ZipEntry.Crc

`Chilkat 11.7.0 · sqlserver · ZipEntry · Crc · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'Crc', @iValue OUT
```

The CRC value for this ZIP entry.

For AES-encrypted entries, the CRC value is `0`.

### ZipEntry.EncryptionKeyLen

`Chilkat 11.7.0 · sqlserver · ZipEntry · EncryptionKeyLen · property · read-only · since 9.5.0.69`

```sql
EXEC sp_OAGetProperty @zipEntry, 'EncryptionKeyLen', @iValue OUT
```

The AES encryption key length for this entry.

If this entry is AES encrypted, the value is `128`, `192`, or `256`.

If this entry is not AES encrypted, the value is `0`.

### ZipEntry.EntryID

`Chilkat 11.7.0 · sqlserver · ZipEntry · EntryID · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'EntryID', @iValue OUT
```

A unique identifier assigned to this entry while the ZIP object is instantiated in memory.

This ID can be used to retrieve the same entry later with `Zip.EntryById`.

### ZipEntry.EntryType

`Chilkat 11.7.0 · sqlserver · ZipEntry · EntryType · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'EntryType', @iValue OUT
```

Indicates the origin and current state of this ZIP entry.

- `0` — Mapped Entry: an entry that already exists in an open ZIP file.
- `1` — File Entry: a file in the local filesystem that has been referenced, but not yet read or compressed.
- `2` — Data Entry: an entry containing uncompressed data already held in memory.
- `3` — Null Entry: an entry that no longer exists in the ZIP archive.
- `4` — New Directory Entry: a directory entry added to the ZIP object.

When the ZIP archive is written by calling `WriteZip` or `WriteToMemory`, entries are transformed into mapped entries. In other words, after writing, they point to compressed data contained in the newly created or rewritten ZIP archive.

### ZipEntry.FileDateTimeStr

`Chilkat 11.7.0 · sqlserver · ZipEntry · FileDateTimeStr · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'FileDateTimeStr', @sValue OUT
EXEC sp_OASetProperty @zipEntry, 'FileDateTimeStr', @sValue
```

Gets or sets the local last-modified date/time for this ZIP entry in RFC 822 string format.

Example RFC 822 date/time strings:

> `Tue, 15 Nov 1994 12:45:26 GMT Fri, 05 Jan 2024 18:30:00 -0500`

The timezone may be specified either as a named timezone such as `GMT`, or as a numeric UTC offset such as `-0500`.

### ZipEntry.FileName

`Chilkat 11.7.0 · sqlserver · ZipEntry · FileName · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'FileName', @sValue OUT
EXEC sp_OASetProperty @zipEntry, 'FileName', @sValue
```

Gets or sets the filename, including any relative path, stored for this entry inside the ZIP archive.

Changing this property changes the path/name that will appear in the ZIP archive. It does not rename a source file in the local filesystem.

### ZipEntry.FileNameHex

`Chilkat 11.7.0 · sqlserver · ZipEntry · FileNameHex · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'FileNameHex', @sValue OUT
```

Returns the raw filename bytes found in the ZIP entry, encoded as a hexadecimal string.

This can be useful for diagnosing filename encoding issues.

### ZipEntry.IsAesEncrypted

`Chilkat 11.7.0 · sqlserver · ZipEntry · IsAesEncrypted · property · read-only · since 9.5.0.69`

```sql
EXEC sp_OAGetProperty @zipEntry, 'IsAesEncrypted', @iValue OUT
```

Indicates whether this ZIP entry is AES encrypted.

This property can be `1` only for entries already contained in a ZIP archive, such as entries obtained after calling `OpenZip`, `OpenBd`, or `OpenFromMemory`.

If the entry is not AES encrypted, the property is `0`.

### ZipEntry.IsDirectory

`Chilkat 11.7.0 · sqlserver · ZipEntry · IsDirectory · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'IsDirectory', @iValue OUT
```

Indicates whether this ZIP entry is a directory entry.

The value is `1` if the entry represents a directory, and `0` if it represents a file.

### ZipEntry.TextFlag

`Chilkat 11.7.0 · sqlserver · ZipEntry · TextFlag · property · read/write`

```sql
EXEC sp_OAGetProperty @zipEntry, 'TextFlag', @iValue OUT
EXEC sp_OASetProperty @zipEntry, 'TextFlag', @iValue
```

Gets or sets the text flag in the internal file attributes for this ZIP entry.

This flag indicates whether the entry contents should be considered text rather than binary data.

The flag is informational and does not need to be accurate for normal ZIP processing. It is provided for compatibility with applications that may be sensitive to this attribute.

### ZipEntry.UncompressedLength

`Chilkat 11.7.0 · sqlserver · ZipEntry · UncompressedLength · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'UncompressedLength', @iValue OUT
```

The uncompressed size of this entry, in bytes.

### ZipEntry.UncompressedLengthStr

`Chilkat 11.7.0 · sqlserver · ZipEntry · UncompressedLengthStr · property · read-only`

```sql
EXEC sp_OAGetProperty @zipEntry, 'UncompressedLengthStr', @sValue OUT
```

The uncompressed size of this ZIP entry as a decimal string.

This is useful when the uncompressed size may be larger than what can safely be represented by a 32-bit integer.

## Methods

### ZipEntry.AppendString

`Chilkat 11.7.0 · sqlserver · ZipEntry · AppendString · method`

```sql
EXEC sp_OAMethod @zipEntry, 'AppendString', @success OUT, @strContent, @charset
```

Appends text data to this ZIP entry's file contents.

The text is converted to bytes using the character encoding specified by `charset`, such as `utf-8`, `utf-16`, or `ansi`.

If this entry is already a Data Entry (`EntryType = 2`), then the encoded bytes are appended directly to the existing uncompressed in-memory data.

If this entry is not already a Data Entry, then the entry is first converted into a Data Entry before the new text data is appended.

- If the entry is a mapped entry (`EntryType = 0`), the compressed ZIP entry data is first inflated into memory. The new text data is then appended, and the entry becomes a Data Entry containing the combined uncompressed data.
- If the entry is a file entry (`EntryType = 1`), the referenced filesystem file is first loaded into memory. The new text data is then appended, and the entry becomes a Data Entry containing the combined data.

After this method is called, the entry contents exist entirely as uncompressed in-memory data associated with the ZipEntry object.

Returns 1 for success, 0 for failure.

### ZipEntry.CopyToBase64

`Chilkat 11.7.0 · sqlserver · ZipEntry · CopyToBase64 · method`

```sql
EXEC sp_OAMethod @zipEntry, 'CopyToBase64', @sResult OUT
```

Returns the compressed data for this ZIP entry as a Base64-encoded string.

This method can only be used when the entry already contains compressed data, meaning the entry is a mapped entry.

This is possible for entries from a ZIP archive that has already been opened, or after writing a ZIP archive while it remains open.

Returns `NULL` on failure

### ZipEntry.CopyToHex

`Chilkat 11.7.0 · sqlserver · ZipEntry · CopyToHex · method`

```sql
EXEC sp_OAMethod @zipEntry, 'CopyToHex', @sResult OUT
```

Returns the compressed data for this ZIP entry as a hexadecimal encoded string.

This method can only be used when the entry already contains compressed data, meaning the entry is a mapped entry.

This is possible for entries from a ZIP archive that has already been opened, or after writing a ZIP archive while it remains open.

Returns `NULL` on failure

### ZipEntry.Extract

`Chilkat 11.7.0 · sqlserver · ZipEntry · Extract · method`

```sql
EXEC sp_OAMethod @zipEntry, 'Extract', @success OUT, @dirPath
```

Extracts this ZIP entry beneath the specified base directory.

The entry is extracted according to the relative path stored in the ZIP archive.

For example, if the entry filename is `docs/readme.txt` and `dirPath` is `c:/temp/output`, the file is extracted to `c:/temp/output/docs/readme.txt`.

Use `ExtractInto` instead if the file should be extracted directly into a specific directory regardless of the path stored in the ZIP archive.

Returns 1 for success, 0 for failure.

### ZipEntry.ExtractInto

`Chilkat 11.7.0 · sqlserver · ZipEntry · ExtractInto · method`

```sql
EXEC sp_OAMethod @zipEntry, 'ExtractInto', @success OUT, @dirPath
```

Extracts this entry directly into the specified directory, ignoring any path information stored in the ZIP entry.

For example, if the entry filename is `docs/readme.txt` and `dirPath` is `c:/temp/output`, the file is extracted to `c:/temp/output/readme.txt`.

If this entry is a directory entry, nothing is extracted. To create the directory represented by a directory entry, use `Extract` instead.

Returns 1 for success, 0 for failure.

### ZipEntry.GetNext

`Chilkat 11.7.0 · sqlserver · ZipEntry · GetNext · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zipEntry, 'GetNext', @success OUT
```

Updates this `ZipEntry` object so that it represents the next entry in the same ZIP archive.

The next entry may be either a file entry or a directory entry.

Returns `1` if the object was advanced to the next entry. Returns `0` if there are no more entries.

### ZipEntry.GetNextMatch

`Chilkat 11.7.0 · sqlserver · ZipEntry · GetNextMatch · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zipEntry, 'GetNextMatch', @success OUT, @pattern
```

Updates this `ZipEntry` object so that it represents the next entry in the ZIP archive matching the specified wildcard pattern.

The wildcard character `*` matches zero or more characters. Matching is performed against the full stored filename, including any relative path.

The matching entry may be either a file entry or a directory entry.

Returns `1` if a matching entry is found. Returns `0` if no further matching entry exists.

### ZipEntry.ReplaceString

`Chilkat 11.7.0 · sqlserver · ZipEntry · ReplaceString · method`

```sql
EXEC sp_OAMethod @zipEntry, 'ReplaceString', @success OUT, @strContent, @charset
```

Replaces this ZIP entry's existing contents with new text data.

The text is converted to bytes using the character encoding specified by `charset`, such as `utf-8` or `ansi`.

The resulting bytes become the complete contents of the entry.

Returns 1 for success, 0 for failure.

### ZipEntry.SetDt

`Chilkat 11.7.0 · sqlserver · ZipEntry · SetDt · method`

```sql
EXEC sp_OAMethod @zipEntry, 'SetDt', NULL, @dt
```

Sets the last-modified date/time for this ZIP entry.

The `dt` argument is a `CkDateTime` object containing the date/time to store for the entry.

### ZipEntry.UnzipToBd

`Chilkat 11.7.0 · sqlserver · ZipEntry · UnzipToBd · method · since 9.5.0.67`

```sql
EXEC sp_OAMethod @zipEntry, 'UnzipToBd', @success OUT, @binData
```

Unzips this entry directly into a `BinData` object.

The uncompressed bytes are written to `binData`.

Returns 1 for success, 0 for failure.

### ZipEntry.UnzipToSb

`Chilkat 11.7.0 · sqlserver · ZipEntry · UnzipToSb · method · since 9.5.0.67`

```sql
EXEC sp_OAMethod @zipEntry, 'UnzipToSb', @success OUT, @lineEndingBehavior, @srcCharset, @sb
```

Unzips this entry as text and appends the result to a `StringBuilder`.

The `srcCharset` argument specifies how the uncompressed bytes should be interpreted, such as `utf-8`, `utf-16`, or `windows-1252`.

The `lineEndingBehavior` argument controls line-ending conversion:

- `0` — leave line endings unchanged.
- `1` — convert all line endings to bare LF.
- `2` — convert all line endings to CRLF.

Returns 1 for success, 0 for failure.

### ZipEntry.UnzipToStream

`Chilkat 11.7.0 · sqlserver · ZipEntry · UnzipToStream · method · since 9.5.0.67`

```sql
EXEC sp_OAMethod @zipEntry, 'UnzipToStream', @success OUT, @toStream
```

Unzips this entry to a stream.

If called synchronously, the `toStream` must have a sink, such as a file or another stream object.

If called asynchronously, the foreground thread can read from the stream while the unzip operation writes to it.

Returns 1 for success, 0 for failure.

### ZipEntry.UnzipToString

`Chilkat 11.7.0 · sqlserver · ZipEntry · UnzipToString · method`

```sql
EXEC sp_OAMethod @zipEntry, 'UnzipToString', @sResult OUT, @lineEndingBehavior, @srcCharset
```

Inflates this entry and returns the uncompressed data as a string.

The `srcCharset` argument specifies how the uncompressed bytes should be interpreted, such as `utf-8`, `utf-16`, or `windows-1252`.

The `lineEndingBehavior` argument controls line-ending conversion:

- `0` — leave line endings unchanged.
- `1` — convert all line endings to bare LF.
- `2` — convert all line endings to CRLF.

Returns `NULL` on failure

## Events and callbacks

This binding has no event callbacks.

## Deprecated members — do not use in new code

| Member | Kind | Deprecated in | Use instead |
|---|---|---|---|
| `GetDt` | method | before 11.6.1 | — |
| `NextEntry` | method | before 11.6.1 | `GetNext` |
| `NextMatchingEntry` | method | before 11.6.1 | `GetNextMatch` |

## Related classes

[`BinData`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/BinData.md), [`CkDateTime`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/CkDateTime.md), [`Stream`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/Stream.md), [`StringBuilder`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/StringBuilder.md)

