TablePlus / TableTool-issue-tracker

2 stars 0 forks source link

Request for text encoding support #8

Open mkismy opened 1 month ago

mkismy commented 1 month ago

When I try to open csv file created in "Shift JIS", or encoding="cp932" when specifying in python, the error below is shown.

I guess files that are not created in utf8 is currently not supported so I'm filing a feature request for text encoding.

Invalid Input Error: CSV Error on Line: 1
Invalid unicode (byte sequence mismatch) detected.

Possible Solution: Enable ignore errors (ignore_errors=true) to skip this row

file=/Users/user/FILE.CSV
delimiter = , (Auto-Detected)
quote = " (Auto-Detected)
escape = \0 (Auto-Detected)
new_line = Single-Line File (Auto-Detected)
header = false (Auto-Detected)
skip_rows = 0 (Auto-Detected)
comment = \0 (Auto-Detected)
date_format =  (Auto-Detected)
timestamp_format =  (Auto-Detected)
null_padding=0
sample_size=20480
ignore_errors=false
all_varchar=0
huyphams commented 1 month ago

Thanks @mkismy we should have added the encoding option in custom import.