Discussion Board for collaboration on QlikView Scripting.
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 .
check this support article: https://support.qlik.com/articles/000037586
View solution in original post
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-...
ODBC connection with Qlikview: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/OLEDB_ODBC.htm
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.
check this from help: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/data-...
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.