Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
Creator

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
fosuzuki
Partner
Partner

4 Replies
rushikale0106
Contributor III
Contributor III

Hello @Architect ,

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

fosuzuki
Partner
Partner

Architect
Creator
Creator
Author

@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.

fosuzuki
Partner
Partner