UTF8 data in Squirrel client
I am using squirrel client to query UTF8 Data in the vertica tables and i observed that there are boxes in the data and when exported to text file they appear as '?' question mark.
I fired the same query using the vsql client and got the following warning.
"
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See vsql reference
page "Notes for Windows users" for details.
"
Using the vertica documentation i changed the code page
cmd.exe /c chcp 1252 and logged in using the vsql command. After doing this I was able to get the correct output on the windows box with the vsql client.
But as squirrel client does not use the vsql client and uses the jar to connect to vertica is there any other option available in the connection parameters that can used so that the UTF data can be correctly read from Vertica Database?
I tried using the connect string as suggested in the documentation but it doesn't work as expected.
jdbc:vertica://<hostname>:<port>/?chanracterEncoding=UTF8