Script ExecuteStream and UseUnicode?

[upscene]

Hi,

When using ExecuteStream on the script component, what Encoding should the stream use and does it require a "preamble" if UseUnicode on the Connection is set to True?

And what about other character sets?

What Encoding does using the Execute method use when executing the script in the SQL property of the script component?

Example:

Code: Select all

  s := TStringStream.Create(Memo1.Text, TEncoding.UTF8);
  s := TFileStream.Create('C:\Users\Martijn\Documents\Database Workbench 5 Pro\scripttest_utf8.sql', fmOpenRead);
  try
    MyScript1.ExecuteStream(s);
  finally
    s.Free;
  end;

Using the stringstream works, using the file to open a UTF8 encoded file, including "preamble" fails. Using Unicode as the encoding on the string stream fails with: "
Parser: The unknown symbol ' "

Any clue? Using MyDAC 8.5.14 Delphi 2009.

With regards,

Martijn Tonies

[ViktorV]

Thank you for the information. We are investigating this behavior of MyDAC, and we will inform you about the results.

[upscene]

Any news yet?

with regards,

Martijn

[ViktorV]

We continue the problem investigation and we'll inform you as soon as we get any results.

[upscene]

Have you been able to reproduce this issue?

[ViktorV]

The fix for TMyScript functioning when working with UTF8 files will be included in the next MyDAC build.

[upscene]

And other streams, I hope, as long as they have a "preamble" available?

[ViktorV]

Are you asking whether any "preamble" will be used on file loading? If yes, then what other "preambles" do you mean?

[upscene]

I meant, is the updated version able to use any type of stream and read it properly, as long as the stream contains the "preamble sequence of bytes" that described the type of data is provides in the stream?

I'm asking, cause I noticed differences in using TStringStream and TFileStream.

[ViktorV]

Yes, you are right. MyDAC takes preamble into account on script execution from a thread independently on the class type: TFileStream or TStringSream.

[upscene]

Any release date set yet?

[ViktorV]

The new MyDAC build with a fix for TMyScript functioning when working with UTF8 files are available for download now.

[upscene]

Excellent, thank you.