Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

QlikView Datatype, and how ODBC connect Database with QV.

Please, anyone, provide me any details on the datatypes used in QlikView,

and how it works while connecting with databases with ODBC connection.

I need to understand how multibyte or single-byte data from Database can be imported into the Qlikview using ODBC.

Please provide any link, that can explain it .

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

4 Replies
Highlighted
Contributor III
Contributor III

Hello @gaurab_basu ,

To answer your question please go through the following links.

Datatypes in Qlikview and its interpretation: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/data-...

https://data-flair.training/blogs/qlikview-data-types/

ODBC connection with Qlikview: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/OLEDB_ODBC.htm

https://mindmajix.com/connect-odbc-ole-db-data-sources-using-qlikview

How ODBC works: https://data-flair.training/blogs/qlikview-odbc-oledb/

 

Hope these links will help you to understand the solutions you asked.

Let me know if you find it useful.

Regards,

Rushi

Highlighted
Highlighted
Contributor III
Contributor III

@fosuzuki 

@rushikale0106 

Thank you for your input.

I have gone through the documents, but there is one fundamental question,

When QlikView will fail to load data, and why? 

Because, In my project, I have encountered that Qlikview does not support Multibyte characters. and throwing below error-->

"Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 29275, ErrorMsg: [Oracle][ODBC][Ora]ORA-29275: partial multibyte character"

In this context can you please explain how we can represent Chinese/Japanese characters in QlikView, Because what we know these characters are mostly multibyte. Then how we work with these Japanese/Chinese characters?

Please help me understand this issue.

Highlighted
Partner
Partner