Re: SQLRetrive does not fetch completes japanese data.
there is one workaround.
You can set the OS to a Japanese code page and
convert the text to that code page.
Then Robot will be able to understand it.
I think the connection string has a parameter for what code page to return text in.