<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic While I didn't test these… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Chinese-characters-displayed-as-Question-marks/m-p/75209#M27814</link>
    <description>While I didn't test these hypotheses, this is either an encoding issue or a display one.
If it is a display issue, then the data is there and you can use it, but the font Blue Prism is using cannot display&amp;nbsp;the characters. To check this, verify the following:
Try to enter Chinese characters in the collection's display
Try to copy the question marks from Blue Prism and paste them into a different location. Ensure that the other location is using the same font as Excel.

If it is an encoding issue, then the data on clipboard cannot be converted to the encoding Blue Prism uses, so you actually lose data. This would be weird, because:
Get Worksheet As Collection is using this line of code to get the contents, which is getting data in an UTF-16 encoding
		Dim data As String = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True)
Strings are most likely stored UTF-16 as well.

For encoding issues, you may try these other options:
Clipboard.GetText(): it is supposed to do the same, it works for me with Cyrillic and Greek characters (which is why you may be dealing with a display issue)
OLEDB may also work.</description>
    <pubDate>Tue, 13 Nov 2018 20:22:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-11-13T20:22:00Z</dc:date>
    <item>
      <title>Chinese characters displayed as Question marks</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Chinese-characters-displayed-as-Question-marks/m-p/75208#M27813</link>
      <description>When I execute get worksheet as collection it is giving me ? marks instead of Chinese characters from Excel

&amp;nbsp;

The&amp;nbsp; characters are displayed as Chinese in Excel but in Blue Prism they are ? marks. Any solution for this?</description>
      <pubDate>Tue, 13 Nov 2018 13:17:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Chinese-characters-displayed-as-Question-marks/m-p/75208#M27813</guid>
      <dc:creator>Srikanthabburu</dc:creator>
      <dc:date>2018-11-13T13:17:00Z</dc:date>
    </item>
    <item>
      <title>While I didn't test these…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Chinese-characters-displayed-as-Question-marks/m-p/75209#M27814</link>
      <description>While I didn't test these hypotheses, this is either an encoding issue or a display one.
If it is a display issue, then the data is there and you can use it, but the font Blue Prism is using cannot display&amp;nbsp;the characters. To check this, verify the following:
Try to enter Chinese characters in the collection's display
Try to copy the question marks from Blue Prism and paste them into a different location. Ensure that the other location is using the same font as Excel.

If it is an encoding issue, then the data on clipboard cannot be converted to the encoding Blue Prism uses, so you actually lose data. This would be weird, because:
Get Worksheet As Collection is using this line of code to get the contents, which is getting data in an UTF-16 encoding
		Dim data As String = Clipboard.GetDataObject().GetData(DataFormats.UnicodeText, True)
Strings are most likely stored UTF-16 as well.

For encoding issues, you may try these other options:
Clipboard.GetText(): it is supposed to do the same, it works for me with Cyrillic and Greek characters (which is why you may be dealing with a display issue)
OLEDB may also work.</description>
      <pubDate>Tue, 13 Nov 2018 20:22:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Chinese-characters-displayed-as-Question-marks/m-p/75209#M27814</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-11-13T20:22:00Z</dc:date>
    </item>
  </channel>
</rss>

