elastic / elastic/elasticsearch-sql-odbc

ODBC Error: Invalid character value for cast specification

Open
#327 22 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
18
Forks
33
Avg merge
1d 16h
Merged PRs (30d)
4

Description

I am using ODBC driver version 8.15.1-windows-x86_64 connecting to an ElasticSearch server running version 8.15.1. When I attempt to query data from an ElasticSearch table I am getting this ODBC error: **[Elastic][EsODBC 8.15.1(v8.15.0-1-g43209d3,u,r) Driver]Invalid character value for cast specification;**

When I turn on ODBC error logging I get this message: **Mon Nov 18 12:12:53 2024 - [ERROR] sql2c_string()@convert.c:3489 [STMT@0x0000017FEFACF0B0] can't convert `Soham Sarkar` to double.**

Is there a way to determine which column the bad data is in from the ODBC error message?

Let me know if you need any more information.

Thanks,
Rick L.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.