FASTBCP_UID_STRING_CASING

Overview

The FASTBCP_UID_STRING_CASING environment variable controls whether UID (UUID) values are converted to lowercase or uppercase strings in the output.

The default is lowercase, which follows RFC 4122 standard formatting (e.g. 550e8400-e29b-41d4-a716-446655440000).

Syntax

Windows

$env:FASTBCP_UID_STRING_CASING = "upper"

Linux/macOS

export FASTBCP_UID_STRING_CASING=upper

Configuration

Property	Value
Type	lower / upper
Default	lower
Applies to	All output formats that serialize UID columns as strings
Since	FastBCP 1.0

Values

Value	Output example
lower (default)	550e8400-e29b-41d4-a716-446655440000
upper	550E8400-E29B-41D4-A716-446655440000

Examples

Export with uppercase UIDs (PowerShell)

$env:FASTBCP_UID_STRING_CASING = "upper"

fastbcp -S myserver.database.windows.net `
    -d MyDatabase `
    -T dbo.MyTable `
    --fileoutput "output.csv"

Export with uppercase UIDs (Linux/macOS)

export FASTBCP_UID_STRING_CASING=upper

fastbcp -S myserver.database.windows.net \
    -d MyDatabase \
    -T dbo.MyTable \
    --fileoutput "output.csv"

Restore default lowercase (RFC 4122)

Windows

$env:FASTBCP_UID_STRING_CASING = "lower"

Linux/macOS

export FASTBCP_UID_STRING_CASING=lower