Solved: Re: QlikView Datatype, and how ODBC connect Databa... - Qlik Community - 1733979

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

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

Hi,

check this support article: https://support.qlik.com/articles/000037586

View solution in original post

4 Replies

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

Hi,

check this from help: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/data-...

Author

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.

Hi,

check this support article: https://support.qlik.com/articles/000037586