I am using Vertica DB with third party API but I am getting error on VARCHAR column.
When I am using same API with MySQL DB, It's working fine with VARCHAR but It's not working with Vertica VARCHAR data.
I have checked with third party API, They told me there is problem in VSQL Driver because It's returning a different data type for VARCHAR column.
Is it true? If yes than how I will resolve this problem.
I need data in MySQL VARCHAR format.
Please help me ASAP
I am using Vertica DB with third party API but I am getting error on VARCHAR column.
+1Hi!
Are you connecting via ODBC or JDBC?
If ODBC check "ColumnsAsChar" ODBC parameter
https://my.vertica.com/docs/6.1.x/HTML/index.htm#12800.htm
Since Vertica supports for UTF-8 only, so Vertica's strings are SQL_WCHAR and SQL_WVARCHAR and not SQL_CHAR and SQL_VARCHAR.
Are you connecting via ODBC or JDBC?
If ODBC check "ColumnsAsChar" ODBC parameter
https://my.vertica.com/docs/6.1.x/HTML/index.htm#12800.htm
PSHow character column types are reported when the driver is in Unicode mode. When set to false, the ODBC driver reports the data type of character columns as WCHAR. If you set ColumnsAsChar to true, the driver identifies character column as CHAR.
This setting is normally used for compatibility with some third-party clients such as Informatica.
Since Vertica supports for UTF-8 only, so Vertica's strings are SQL_WCHAR and SQL_WVARCHAR and not SQL_CHAR and SQL_VARCHAR.
Hi Daniel Leybovich
We are using Vertica JDBC driver (com.vertica.jdbc.Driver).
Thanks & Best Regards
==================
Anand Singh
We are using Vertica JDBC driver (com.vertica.jdbc.Driver).
Thanks & Best Regards
==================
Anand Singh
+1Ok.
Define logging and post a logger output (see Logging Properties): https://my.vertica.com/docs/6.1.x/HTML/index.htm#13173.htm
Use for www.pastebin.com or whatever for it, this forum has horrible formatting.
Example
Define logging and post a logger output (see Logging Properties): https://my.vertica.com/docs/6.1.x/HTML/index.htm#13173.htm
Use for www.pastebin.com or whatever for it, this forum has horrible formatting.
Example
---
LogLevel = "DEBUG"LogNameSpace = "com.vertica"LogPath = ??? (define path, for example /tmp/vertica_jdbc.log )
---
PS
Can you say also what 3-rd party API do you use?
I want to try to reproduce.
Hi Daniel Leybovich,
We are using Content Analyst (CAAT)
We are providing data base connection and SELECT query info to CAAT.
If we are using MySQL It's taking data from MySQL but when we are using VSQL it's throwing exception.
We are using Content Analyst (CAAT)
We are providing data base connection and SELECT query info to CAAT.
If we are using MySQL It's taking data from MySQL but when we are using VSQL it's throwing exception.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
