topic Re: QlikView Datatype, and how ODBC connect Database with QV. in QlikView

QlikView Datatype, and how ODBC connect Database with QV.

Architect — Fri, 07 Aug 2020 06:01:47 GMT

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 .

Re: QlikView Datatype, and how ODBC connect Database with QV.

rushikale0106 — Fri, 07 Aug 2020 07:17:38 GMT

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-types.htm#:~:text=QlikView%20can%20handle%20text%20strings,can%20be%20used%20in%20calculations.

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

Re: QlikView Datatype, and how ODBC connect Database with QV.

fosuzuki — Fri, 07 Aug 2020 08:07:54 GMT

Hi,

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

Re: QlikView Datatype, and how ODBC connect Database with QV.

Architect — Sat, 08 Aug 2020 07:51:26 GMT

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

Re: QlikView Datatype, and how ODBC connect Database with QV.

fosuzuki — Mon, 10 Aug 2020 12:11:44 GMT

Hi,

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