My request is like: [Prepared Select Statement] SELECT CONCAT("text=", text) AS text FROM table_templates where name=? and lang="chi"; The "Response Data" are shown in the "View Result Three" window as: -------------- text text=????????????? -------------- ER: the "?" should be Unicode characters - in my case Chinese.
This probably depends on the default encoding. The JDBC Sampler uses the default encoding to store the string in the SampleResult. If this encoding does not support Chinese, then some characters will be lost when the translation is performed. What does the JMeter log file show for the file.encoding?
Forgot to add that the Tree View will only be able to display the Chinese characters if the JVM font supports it.
Sampler has been updated to always use UTF-8 for conversions: URL: http://svn.apache.org/viewvc?rev=703617&view=rev Log: Bug 45425 - JDBC Request does not support Unicode Hopefully this will solve the problem. The fix will be in nightly builds after r703617. Please re-open if it still does not work.
svn 703755 Verified - JDBC response is showing UNICODE in "View Result Tree"-"Response Data" tab. Closing
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/2135