Error: Something about storing 8bit data

Moderator: NorbertKrupa

Post Reply
User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Error: Something about storing 8bit data

Post by becky » Thu Feb 14, 2013 3:49 pm

Hi,

I am getting a weird error when I query a column from a table (see attachment) in dbVisualizer.

The query is simply:

Code: Select all

select search_path from sdk_software.schedule;
If I run the same query in vsql it does not return an error!

Any idea what this error means or how I can fix it?
Attachments
weird-error.png
Error from dbVisualizer
weird-error.png (13.79 KiB) Viewed 39186 times
THANKS - BECKSTER

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Error: Something about storing 8bit data

Post by JimKnicely » Thu Feb 14, 2013 5:01 pm

Becky,

Are you using the Vertica JDBC drivers? You are probably getting an error with non-UTF8 characters somewhere in that column. You can check if there are any funky characters with the ISUTF8 function.

Run this is vsql:

Code: Select all

SELECT search_path from sdk_software.schedule WHERE isutf8(search_path) = 'f';
See if you get any records back!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
becky
Intermediate
Intermediate
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: Error: Something about storing 8bit data

Post by becky » Thu Feb 14, 2013 6:50 pm

Hi Jim!

Your query returned one record. We originally loaded the data into the Vertica table from an Excel spreadsheet saved as a CSV file. I examined the row in the spreadsheet for the record your query returned and noticed that it has a "dash" character. I changed it to a "hyphen", reloaded the data, and wa- lah, the error in dbVisualizer disappeared!

So, is it Vertica that doesn't like the dash, or is dbVisualizer?

Thank you very much for your assistance on this!
THANKS - BECKSTER

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Error: Something about storing 8bit data

Post by JimKnicely » Thu Feb 14, 2013 7:01 pm

Cool!

Did you want it to be a hyphen? Typically in MS Word and Excel when you insert hyphens, some of the hyphens are converted into long dashes (also called en dashes). I find that annoying. Did you load the file from Windows?
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Re: Error: Something about storing 8bit data

Post by sarah » Fri Feb 15, 2013 12:46 am

Hey Becky,

We had a similar issue. If you switch dbVisualizer to to use the JBDC/ODBC driver as opposed to the JDBC driver you won't get that error. However, the characters that can't be displayed (non UTF8) will appear as little squares...
Have a GREAT day!

Post Reply

Return to “dbVisualizer”