通过powershell从火鸟数据库读取使用WIN1251编码的数据

# 导入Firebird数据提供程序
Add-Type -Path "C:\Path\To\FirebirdSql.Data.FirebirdClient.dll"

# 设置数据库连接字符串
$connectionString = "User=your_username;Password=your_password;Database=your_database;DataSource=your_server;Charset=WIN1251"

# 创建数据库连接
$connection = New-Object FirebirdSql.Data.FirebirdClient.FbConnection($connectionString)

# 打开数据库连接
$connection.Open()

# 创建查询命令
$query = "SELECT * FROM your_table"

# 创建命令对象
$command = New-Object FirebirdSql.Data.FirebirdClient.FbCommand($query, $connection)

# 执行查询并获取数据读取器
$reader = $command.ExecuteReader()

# 循环读取数据
while ($reader.Read()) {
    # 读取数据并进行处理
    $column1 = $reader["column1"]
    $column2 = $reader["column2"]
    # 其他列...

    # 输出数据
    Write-Host "Column 1: $column1, Column 2: $column2"
}

# 关闭数据读取器、命令和连接
$reader.Close()
$command.Dispose()
$connection.Close()