Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Pandas.StringDtype #16

Open
jdglaser opened this issue Apr 30, 2021 · 1 comment
Open

Add support for Pandas.StringDtype #16

jdglaser opened this issue Apr 30, 2021 · 1 comment

Comments

@jdglaser
Copy link
Owner

pandas.StringDtype is still experimental, but we should probably add support for it.

@wanwencwanwenc
Copy link

wanwencwanwenc commented Jul 26, 2021

I have a similar issue when load NaN to SQL. The column I have issue with is an Object in dataframe. The value is NaN. I use ODBC Driver 17 for SQL Server as my driver and I tried to ingest the data to MS SQL database.

When I use to_sql() function. I have no issues.

But when I use fast_to_sql(), I have below errors:

The error message I have is:
DataError: ('22018', '[22018] [Microsoft][ODBC Driver 17 for SQL Server]Invalid character value for cast specification (0) (SQLParamData)')

I think it is failed because of the NaN value.

Thank you for taking a look!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants