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.

Sign up for GitHub

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

Jump to bottom

nullbyte #64

Closed

ondrejhlavacek opened this issue Oct 12, 2018 · 2 comments

Labels

bug

Member

ondrejhlavacek commented Oct 12, 2018

Do Storage se z MSSQL dostává nullbyte. Nejde nikde vidět, v Snowflake se na něj musí opatrně

"NULLBYTE" != NULL (nullbyte není null)
UNICODE("NULLBYTE") = 0 (hodnota nullbyte je 0)
UNICODE('') = 0 (prázdnej string vrátí taky 0)
NULLBYTE != '' (avšak nullbyte není prázdnej string)

Pokud stáhnu soubory pro import do storage (ať už přímo z MSSQL nebo z nějaký transformace, kudy nullbyte krásně plynule proteče), v hexa je vidět

https://keboola.slack.com/archives/C06BK8K1Q/p1539331178000100
https://keboola.zendesk.com/agent/tickets/9288

The text was updated successfully, but these errors were encountered:

ondrejhlavacek added the bug label

Contributor

tomasfejfar commented Oct 16, 2018

Contributor

pivnicek commented Oct 17, 2018

@ondrejhlavacek this should be resolved as of release https://github.com/keboola/db-extractor-mssql/releases/tag/3.0.4

pivnicek closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment