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

UTF-8 character insert errors #52

Open
tcederquist opened this issue Dec 17, 2019 · 0 comments
Open

UTF-8 character insert errors #52

tcederquist opened this issue Dec 17, 2019 · 0 comments

Comments

@tcederquist
Copy link

Double byte char types like utf-8 such as JP characters are actually a different size in redshift storage for varchar, needs to accommodate these double type types. Can you update the nchar function in tabledefinitions.R line 4 to read:

maxChar = max(nchar(col, type='bytes'), na.rm=T)

Sample code to create the issue:

dat1 <- data.frame(A="あいう",stringsAsFactors = F) b=rs_create_table(dat1, dbcon=con, table_name='mytesttable', split_files=1)

Above results in
ERROR: Load into table 'uvroyetkqxjdgcbn' failed. Check 'stl_load_errors' system table for details.

In stl_load_errors is says
String length exceeds DDL length

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

1 participant