DataFrame with UTF-8

[EckisWelt]

If I load data from a DataFrame which has foreign characters such as äöü, the import loads garbage.

To fix that you would need in the bcp command option: '-C 65001'.

And in the format_file_builder you would need to remove any collation.

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/create-a-format-file-sql-server?view=sql-server-ver15

I'm not sure how it needs to be done to be still flexible with your default file import without UTF-8.

[titan550]

I added these modifications that should do the job. Please try it and let me know.

pip uninstall -y bcpy
pip install --no-index git+https://github.com/titan550/bcpy@b3e8155cfc76e152e15a59b97fb3ed491dc806c4

[anibyeol]

Hi, pip uninstall -y bcpy pip install --no-index git+https://github.com/titan550/bcpy@b3e8155cfc76e152e15a59b97fb3ed491dc806c4

Tried installing this version, but the issue still persists.

[FriiSRS]

Hi, pip uninstall -y bcpy pip install --no-index git+https://github.com/titan550/bcpy@b3e8155cfc76e152e15a59b97fb3ed491dc806c4

Tried installing this version, but the issue still persists.

Same for me

[anibyeol]

Yep, not resolved yet. Chinese characters are loaded like '市政科'

[MVargasP]

Hello, I also have the same problem, still unsolved?