search

Giorgi / DuckDB.NET

Bindings and ADO.NET Provider for DuckDB
https://duckdb.net
MIT License
409 stars 69 forks source link

SQL formatting with special characters #138

Closed kannenberg closed 1 year ago

kannenberg commented 1 year ago

I'm trying to write SQL, but my table has columns with special characters in the name.

I've tried all kinds of coding, but I can't get the column name in the correct format from the other side.

I'm using .NET 7.0

Erro:

Binder Error: Referenced column "_Data In�cio" not found in FROM clause! Candidate bindings: "tbl-3c5fad0d-c811-40d5-b151-4c927d3e5d13._Data Início" LINE 1: SELECT "_Caso", "_Data In�cio", "_Data Fim" ^ Stacktrace:

at DuckDB.NET.Data.PreparedStatement.PrepareMultiple(DuckDBNativeConnection connection, String query, DuckDBParameterCollection parameters) at DuckDB.NET.Data.DuckDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at DuckDB.NET.Data.DuckDbCommand.ExecuteReader()

Giorgi commented 1 year ago

This is probably a duplicate of https://github.com/Giorgi/DuckDB.NET/issues/134

kannenberg commented 1 year ago

Do you have a release date for this version on Nuget?

Giorgi commented 1 year ago

I'll release new version by the start of the next week. In the meantime you can try installing it from GitHub: https://github.com/Giorgi/DuckDB.NET/pkgs/nuget/DuckDB.NET.Data.Full

Giorgi commented 1 year ago

I just pushed 0.9.0 to NuGet, can you check if it solves the issue?

Giorgi commented 1 year ago

I'll close this issue, if it still doesn't work feel free to comment/reopen.

kannenberg commented 11 months ago

Thanks, 0.9.0 it solved the issue.