How to view special characters with UTF-8 encoding using the File-Delimited data source in TIBCO Data Virtualization?
Article ID: KB0072828
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
To view the special characters in TDV, one of the best options present is to use a '.dat' file with a File-Delimited data source.
By default, a File-Delimited data source only has '.csv' and '.txt' files in the 'File Name Filter(s)' field.
So, the user needs to add the option to introspect the '.dat' files in TDV, this can be done as shown below:
File Name Filter(s): *.csv,*.txt, *.dat
Now, the '.dat' files should appear in the Resources list while introspecting the data source.
However, when the user executes the '.dat' file, the output with special characters is not displayed as expected.
Screenshot for reference:
By default, a File-Delimited data source only has '.csv' and '.txt' files in the 'File Name Filter(s)' field.
So, the user needs to add the option to introspect the '.dat' files in TDV, this can be done as shown below:
File Name Filter(s): *.csv,*.txt, *.dat
Now, the '.dat' files should appear in the Resources list while introspecting the data source.
However, when the user executes the '.dat' file, the output with special characters is not displayed as expected.
Screenshot for reference:
Resolution
To view these special characters, the following steps need to be performed:
1. Open the data source.
2. Change the 'Character Set' field to 'utf-8'
3. Save the data source and then re-introspect it.
4. Execute the file and view the results.
The special characters should appear correctly as shown in the screenshot below:
1. Open the data source.
2. Change the 'Character Set' field to 'utf-8'
3. Save the data source and then re-introspect it.
4. Execute the file and view the results.
The special characters should appear correctly as shown in the screenshot below:
Issue/Introduction
This article will summarize how to view special characters with UTF-8 encoding using the File-Delimited data source in TIBCO Data Virtualization.
Feedback
Yes
No
Powered by
