firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not retrive parameter size

[<car...@te...>]

Hello:

> I create SP:
>
> CREATE PROCEDURE TEST (
> WIN1251 VARCHAR(5) CHARACTER SET WIN1251)
> RETURNS (
> UNICODE_FSS VARCHAR(5))
> AS
> begin
> "UNICODE_FSS" = 'test';
> end
>
> and execute code:

Using this i get 2 params for sp_command:

            FbConnection connection = new FbConnection(connectionString);
            connection.Open();

            FbCommand sp_command = new FbCommand("SP_TEST", connection);
            sp_command.CommandType = CommandType.StoredProcedure;

            FbCommandBuilder.DeriveParameters(sp_command);

            connection.Close();



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Parameter size error

[<car...@te...>]

Hello:

> Exception:
>
> An unhandled exception of type 'System.InvalidOperationException' occurred
> in firebirdsql.data.firebird.dll
>
> Additional information: Invalid length of 10 bytes, max length allowed 5
> bytes, for parameter @win1251 index 1


I know this, i have the smae problem this weekend ;) it's changed 
already in the CVS for make the comparsion over the character count 
instead of the byte count.

But with an example like there are problems too:

1. If i send the data encoded using the connection character set ( in 
this case UNICODE_FSS ) the win1251 value is going to give more bytes 
than the sqllen sent by the server for this field.

2. If i send the data using the field character set ( that is how it's 
in the CVS ) we are going to get te "Cannot transliterate characters 
between character sets".




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbCommandBuilder.DeriveParameters not retrive parameter size

[olegmad <ol...@ya...>]

Hello!

I create SP:

CREATE PROCEDURE TEST (
    WIN1251 VARCHAR(5) CHARACTER SET WIN1251)
RETURNS (
    UNICODE_FSS VARCHAR(5))
AS
begin
  "UNICODE_FSS" = 'test';
end

and execute code:

FbCommand sp_command = new FbCommand("TEST", connection, transaction);
sp_command.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(sp_command);

when i looked into sp_command.Parameters array - i see - all Size = 0.

:(

[Firebird-net-provider] Parameter size error

[olegmad <ol...@ya...>]

Hello!

Peter, i take in response your wishes and encoded this email by UTF-8 :)

I create table:
CREATE TABLE "test" (
    "unicode_fss"  VARCHAR(5) CHARACTER SET UNICODE_FSS,
    "win1251"      VARCHAR(5) CHARACTER SET WIN1251
);

Then i try execute code:

string sql = "insert into \"test\" (\"unicode_fss\", \"win1251\") values
(@unicodeValue, @win1251)";

FbCommand unicode_insert = new FbCommand(sql, connection, transaction);

unicode_insert.Parameters.Add("@unicodeValue", FbDbType.VarChar).Value =
"ÞÔÏÔÏ"; // string length = 5

unicode_insert.Parameters.Add("@win1251", FbDbType.VarChar).Value = "ÞÔÏÔÏ";
// string length = 5

unicode_insert.ExecuteNonQuery(); // Exception HERE!!!



Exception:

An unhandled exception of type 'System.InvalidOperationException' occurred
in firebirdsql.data.firebird.dll

Additional information: Invalid length of 10 bytes, max length allowed 5
bytes, for parameter @win1251 index 1



Why i can't post russian string with length 5 in field varchar(5)??? I know
what russian char takes 2 bytes, but i thinking when i create varchar(5) -
it means i can post in this field 5 char (independently of charset). When i
use unicode_fss - all fine...

Thanks.

P.S. I attached full source code sample.


begin 666 full_source.cs
M=7-I;F<@4WES=&5M.PT*=7-I;F<@4WES=&5M+D1A=&$[#0IU<VEN9R!&:7)E
M8FER9%-Q;"Y$871A+D9I<F5B:7)D.PT*#0IN86UE<W!A8V4@0V]N<V]L94%P
M<&QI8V%T:6]N#0I[#0H)8VQA<W,@36%I;D-L87-S#0H)>PT*"0ES=&%T:6,@
M=F]I9"!-86EN*'-T<FEN9UM=(&%R9W,I#0H)"7L-"@D)"7-T<FEN9R!C;VYN
M96-T:6]N4W1R:6YG(#T-"@D)"0E (D1A=&%B87-E/6,Z7'1E;7 N9V1B.R(@
M*PT*"0D)"2)5<V5R/5-94T1"03LB("L-"@D)"0DB4&%S<W=O<F0];6%S=&5R
M:V5Y.R(@*PT*"0D)"2)397)V97(];&]C86QH;W-T.R(@*PT*"0D)"2)0;W)T
M/3,P-3 [(B K#0H)"0D)(D1I86QE8W0],SLB("L-"@D)"0DB0VAA<G-E=#U5
M3DE#3T1%7T934SLB("L-"@D)"0DB<&]O;&EN9SUF86QS93LB("L-"@D)"0DB
M4F]L93T[(CL-"@T*"0D)1F)#;VYN96-T:6]N(&-O;FYE8W1I;VX@/2!N97<@
M1F)#;VYN96-T:6]N*&-O;FYE8W1I;VY3=')I;F<I.PT*"0D)8V]N;F5C=&EO
M;BY/<&5N*"D[#0H-"@D)"49B5')A;G-A8W1I;VX@=')A;G-A8W1I;VX@/2!C
M;VYN96-T:6]N+D)E9VEN5')A;G-A8W1I;VXH*3L-"@T*"0D)<W1R:6YG('-Q
M;" ](")I;G-E<G0@:6YT;R!<(G1E<W1<(B H7")U;FEC;V1E7V9S<UPB+"!<
M(G=I;C$R-3%<(BD@=F%L=65S("A =6YI8V]D959A;'5E+"! =VEN,3(U,2DB
M.PT*#0H)"0E&8D-O;6UA;F0@=6YI8V]D95]I;G-E<G0@/2!N97<@1F)#;VUM
M86YD*'-Q;"P@8V]N;F5C=&EO;BP@=')A;G-A8W1I;VXI.PT*"0D)=6YI8V]D
M95]I;G-E<G0N4&%R86UE=&5R<RY!9&0H(D!U;FEC;V1E5F%L=64B+"!&8D1B
M5'EP92Y687)#:&%R*2Y686QU92 ]("+W\N[R[B([("\O('-T<FEN9R!L96YG
M=&@@/2 U#0H)"0EU;FEC;V1E7VEN<V5R="Y087)A;65T97)S+D%D9"@B0'=I
M;C$R-3$B+"!&8D1B5'EP92Y687)#:&%R*2Y686QU92 ]("+W\N[R[B([("\O
M('-T<FEN9R!L96YG=&@@/2 U#0H)"0EU;FEC;V1E7VEN<V5R="Y%>&5C=71E
M3F]N475E<GDH*3L-"@T*"0D)=')A;G-A8W1I;VXN0V]M;6ET*"D[#0H-"@D)
@"6-O;FYE8W1I;VXN0VQO<V4H*3L-"@D)?0T*"7T-"GT`
`
end

Re: [Firebird-net-provider] FbConfigurationManager Class

[<car...@te...>]

Hello:

> I am using FB 1.5 RC6 with WIN 2000 Pro.
> I have used FbConfiguration Class (Firebird.NET 1.1 Beta 3) in my .NET
> application.
>
> Private conf As FbConfiguration
> conf = New FbConfiguration()
> conf.Database = "x:\xx\xx.fdb"
> conf.UserName = "sysdba"
> conf.UserPassword = "masterkey"
> conf.ServerName = "som.e.i.p"


I have made a little test and seems to work ( version 1.5 from CVS 
against Firebird 1.5 RC7 ), the code ( tell to me if it's correct ):

            FbConfiguration conf = new FbConfiguration();

            conf.Database = @"TESTDB.GDB";
            conf.ServerName = "localhost";
            conf.UserName = "sysdba";
            conf.UserPassword = "masterkey";

            if (conf.State != FbServiceState.Open)
            {
                conf.Open();
            }

            conf.DatabaseShutdown(FbShutdownMode.Forced, 5);




--
Best regards

Carlos Guzmán Álvarez
Vigo-España

Re: [Firebird-net-provider] Re: Re: Character set support

[olegmad <ol...@ya...>]

Hello, Peter!

Here my attached samle...


begin 666 isql.sql
M0U)%051%(%1!0DQ%(")T97-T(B H#0H@(" @(G5N:6-O9&5?9G-S(B @5D%2
M0TA!4B@Q,C@I($-(05)!0U1%4B!3150@54Y)0T]$15]&4U,L#0H@(" @(G=I
M;C$R-3$B(" @(" @5D%20TA!4B@Q,C@I($-(05)!0U1%4B!3150@5TE.,3(U
M,0T**3L-"@T*4T54($Y!3453(%1/(%5.24-/1$5?1E-3.PT*#0I)3E-%4E0@
M24Y43R B=&5S="(@*")U;FEC;V1E7V9S<R(L(")W:6XQ,C4Q(BD@5D%,5453
M("@G[_#NXN7PZN G+" G[_#NXN7PZN G*3L-"@T*4T5,14-4("H@1E)/32 B
(=&5S="([#0H`
`
end

Re: [Firebird-net-provider] Firebird .net events

[<car...@te...>]

Hello:

 >So when I register for an event then I call QueEvents(), I just wait 
till the event >occurs and it automatically calls my method right? As in 
I only register and >queEvents at first and it would call me method 
every time the event occurs?Yes, it's needed to be executed two times, 
this can be a mistake in my implementation but without call it two times 
you well get nothing.

I have reviewed on one sample of the firebird events api ( the one that 
ships with firebird sources ) and if i'm not wrong it makes the call two 
times too.

> Lastly, the program I'm making is multithreaded, does using events 
> require the use of its FbConnection instance exclusively, or once I 
> register and queEvents I can use the same FbConnection for other purposes?

You will need a connection per thread.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbConfigurationManager Class

[Samrat G. <sg...@he...>]

Hi Carlos,

I am using FB 1.5 RC6 with WIN 2000 Pro.
I have used FbConfiguration Class (Firebird.NET 1.1 Beta 3) in my .NET
application.

Private conf As FbConfiguration
conf = New FbConfiguration()
conf.Database = "x:\xx\xx.fdb"
conf.UserName = "sysdba"
conf.UserPassword = "masterkey"
conf.ServerName = "som.e.i.p"


Problem is with this line of code:

"If Not conf.State = FbServiceState.Open Then conf.Open()"
.....
.....
conf.DatabaseShutdown(FbShutdownMode.Forced, 5)

The strangeness is that in Win 2000 Pro with FB 1.5 rc6 and (Firebird.NET
1.1 Beta 3)
there is no error.

But the moment I change my OS to Win XP Home Edition - rest configs same,
this error appears.

"No message for code 472 found.No message for code 243 found."

Can you help me why this error is occurring in WIN XP home edition?

Regards,
sguha.

[Firebird-net-provider] Re: Re: Character set support

[Peter J. <pet...@gm...>]

Hi Oleg, Carlos, All,

Oleg wrote:
> > SET NAMES TO UNICODE_FSS;
> > insert into "test" ("win1251") values ('????????');
> 
> If i try to do like this in isql, it will raise an exception too :(

One of the pains of debugging character set issues, is
the unclear and missing information which arrives over
the mailing list.

I concede that I have an awful setup, as I read this list as 
digest and using a webmail account, but others may be 
affected, too.

In Carlos' post, I can see the right characters when I 
manually set my browser to UTF-8, but in Oleg's post, only
question marks are displayed.

For tests using ISQL I recommended following method:
Prepare a complete ISQL input file (or a set of these
for larger sessions), which includes the DDL creating the
tables and tests itself (by cut + paste your interactive
session). Then test this file with  isql -e -i foo.sql.

Then attach the file zipped to your message.

Regards,
Peter Jacobi

-- 
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net

+++ GMX - die erste Adresse für Mail, Message, More! +++

[Firebird-net-provider] Firebird .net events

[JM F. <jm_...@ly...>]

I just have a question with using events in the .net data provider.  In the sample, the QueEvents() method was invoked twice (how come?), was it to allow the .net program to be informed since another sql was executed?  

So when I register for an event then I call QueEvents(), I just wait till the event occurs and it automatically calls my method right?  As in I only register and queEvents at first and it would call me method every time the event occurs?

Lastly, the program I'm making is multithreaded, does using events require the use of its FbConnection instance exclusively, or once I register and queEvents I can use the same FbConnection for other purposes?

TIA!


____________________________________________________________
Enter now for a chance to win a 42" Plasma Television!
http://ad.doubleclick.net/clk;6413623;3807821;f?http://mocda1.com/1/c/563632/113422/313631/313631
AOL users go here: http://ad.doubleclick.net/clk;6413623;3807821;f?http://mocda1.com/1/c/563632/113422/313631/313631
This offer applies to U.S. Residents Only

Re: [Firebird-net-provider] Re: Character set support

[<car...@te...>]

Hello:

At point 2 this:

Data for fields is being sent using the connection caracter set:

should be:

Data for fields seems to be sent using the field character set:



Sorry ;)


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Character set support

[olegmad <ol...@ya...>]

> SET NAMES TO UNICODE_FSS;
> insert into "test" ("win1251") values ('????????');

If i try to do like this in isql, it will raise an exception too :(

Re: [Firebird-net-provider] Re: Character set support

[olegmad <ol...@ya...>]

Hi, Carlos!

your commit last changes in cvs???

if not, can you send me last dll?

Thanks.

Re: [Firebird-net-provider] Re: Character set support

[<car...@te...>]

Hello:

( i have encoded the email with UTF-8 for better representation of 
special characters )

> Thanks very much for your sample, i'm have done a little C# app
> with the same steps :), give me some time for test it (i can send it 
> to you if you want).

I get the same results as with ISQL sample, but some comments.

1. Select with Win1251 test.

Field C_WIN1251 description sent by the server:

    sqlType     453
    sqlScale    0
    sqlSubType  52      <--- Character set WIN1251
    sqlLen      4     
    sqlInd      0
    sqlName     "C_WIN1251"
    relName     "T1"
    ownerName   "SYSDBA"
    aliasName   "C_WIN1251"

Field C_UTF8 description sent by the server:

    sqlType     453
    sqlScale    0
    sqlSubType  3       <--- Character set UNICODE_FSS
    sqlLen      12      <--- Gives 12 bytes but data is being sent using 
WIN1251
    sqlInd      0
    sqlName     "C_UTF8"
    relName     "T1"
    ownerName   "SYSDBA"
    aliasName   "C_UTF8"

Data for fields is being sent using the connection caracter set:

Bytes for "эле "

    C_WIN1251 = {253, 235, 229, 32}
    C_UTF8    = {235, 235, 229, 32, 32, 32, 32, 32, 32, 32, 32, 32}

String representation:

    C_WIN1251 = "эле "
    C_UTF8    = "эле         "


2. Select with None test ( this is going to use ISO8859_1 that is my 
default caracter
set in .NET ).

Field C_WIN1251 description sent by the server:

    sqlType     453
    sqlScale    0
    sqlSubType  52     <--- Character set WIN1251
    sqlLen      4     
    sqlInd      0
    sqlName     "C_WIN1251"
    relName     "T1"
    ownerName   "SYSDBA"
    aliasName   "C_WIN1251"

Field C_UTF8 description sent by the server:

    sqlType     453
    sqlScale    0
    sqlSubType  3       <--- Character set UNICODE_FSS
    sqlLen      12
    sqlInd      0
    sqlName     "C_UTF8"
    relName     "T1"
    ownerName   "SYSDBA"
    aliasName   "C_UTF8"

Data for fields is being sent using the connection caracter set:

Bytes for "эле ":

    C_WIN1251 = {253, 235, 229, 32}
    C_UTF8    = {209, 141, 208, 187, 208, 181, 32, 32, 32, 32, 32, 32}

String representation:

    C_WIN1251 = "эле "
    C_UTF8    = "эле      "
               
In this case seems to be using the character set of each field, i have 
added a change into the .net data provider for encode strings with field 
character set when NONE is used as default character set, for being sure 
about this issue.

3. Select with UnicodeFss test

This test fails.





After view the results of the test i have made some changes into the 
.NET provider source code
(at this moment only in my local tree)

1. GdsInetReader.cs

Encode strings with field character set when NONE is used as default 
character set.

2. GdsField.cs

New property CharCount that will be used to retrieve the length in 
characters of character fields instead of use SqlLen that is the length 
in bytes.

3. GdsInetReader.cs

If the length of the readed data (in characters) is greater than the 
CharCount of the field, return only CharCount characters ( this will be 
made using the Charset information for the current field ).

4. FbDataReader.cs:

In the GetSchema method save in the ColumnSize field the real number of 
characters for character fields, instead of the length in bytes.



A thing i have noticed ( but i'm not sure if it's a problem or not ) is 
that in charsets.h there are two charsets defined that doesn't appear in 
the RDB$CHARACTER_SETS system table:

#define   CS_JIS_0208            7    /* JIS 0208; 1990   */
#define   CS_UNICODE_UCS2        8    /* UNICODE v 1.10   */



Thanks very much for your test case, very helpful :D

Comments are wellcome :D




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Character set support

[<car...@te...>]

Hello:

> Hi Carlos, All,
>
> When you want to compare ISQL behaviour, you must be
> aware, that ISQL only gets 75% right:
>
> INSERT utf8 => win/iso : OK
> INSERT win/iso => utf8 : OK
> SELECT utf8 => win/iso : OK
> SELECT win/iso => utf8 : FAILS


Thanks very much for your sample, i'm have done a little C# app
with the same steps :), give me some time for test it (i can send it to 
you if you want).



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Character set support

[Peter J. <pet...@gm...>]

Hi Carlos, All,

When you want to compare ISQL behaviour, you must be
aware, that ISQL only gets 75% right:

  INSERT utf8 => win/iso : OK
  INSERT win/iso => utf8 : OK 
  SELECT utf8 => win/iso : OK
  SELECT win/iso => utf8 : FAILS

I've attached a test case (I will bugzilla it
later). As non latin-1 charcters usually
won't get through SF mailing lists, I've done
a ZIP.

Perhaps you have a possibility to intercept 
the wire data for this test case.

Regards,
Peter Jacobi

-- 
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net

+++ GMX - die erste Adresse für Mail, Message, More! +++

Re: [Firebird-net-provider] Character set support

[<car...@te...>]

Hello:

Sorry, this:

> SET NAMES TO UNICODE_FSS;
> insert into "test" values ('????????');

should be:

SET NAMES TO UNICODE_FSS;
insert into "test" ("win1251") values ('????????');




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Character set support

[<car...@te...>]

Hello:

> Yep, I see. 'character sets per field' is rare.

I was making some tests and seems that i need to send the data always in 
UNICODE_FSS ( for the example post by oleg ).

I have a question, for this sample database has UNICODE_FSS, and the 
table has two fields one with UNICODE_FSS character set and one with 
WIN1251, the question is, if for the second field i can or not send the 
data encoded in WIN1251 ( seems that no ) ?? that i think it's the rigth 
way thinking in the field definition.

if i try to do an insert ( using example database ) in ISQL using this:

SET NAMES TO WIN1251;
insert into "test" ("win1251") values ('ÐÒÏ×ÅÒËÁ');

It will raise an exception, i need to do:

SET NAMES TO UNICODE_FSS;
insert into "test" values ('ÐÒÏ×ÅÒËÁ');




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Character set support

[Peter J. <pet...@gm...>]

Hi Carlos, All,

I've changed the subject, to keep it apart from the
actual support question)

> Dou you mean that in sample C# program there are no explicit character 
> set definition for the query parameters ??
> 
> >It would be most helpful to compare the behaviour of other DBMS's 
> >data provider implementations, notable PostgreSQL.
> >
> It's good idea .... (Huuummmmm I have not great knowledge of PostgreSQL 
> but as i know it doesn't allow character sets per field).

Yep, I see. 'character sets per field' is rare.

But from the speed-reading of the samples I've found, I got the
impression, that the .NET string data type is uniformly used to back both
the SQL CHAR and NCHAR types. Which for most SQL vendors map to
'system locale's 8bit character set' and 'UTF-16', respectively.

So, if I didn't get that wrong, there is magic in place, that shield 
users from charset troubles.

Also, still missing facts, let's try logic (and become philosophers and
unemployed?):

Let's say you have installed an additional character set  on the server
(using fbintl2.dll),
for example KOI8R to stay with Russian. 

Now, it's OK to access the database using connection charset Unicode from
another
computer, where this additional character set isn't installed. So the client
doesn't know
anything about KOI8R but everything still works fine. (Just tested with
ISQL, to
make sure I'm not totally off)

If I haven't overlooked a flaw in this argument, the data will travel as 
Unicode over the wire and the neither the Data Provider nor the CLR 
can do any charset conversion itself.

Regards,
Peter Jacobi

-- 
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net

+++ GMX - die erste Adresse für Mail, Message, More! +++

Re: [Firebird-net-provider] I have problem with russian language

[<car...@te...>]

Hello:

> I using your code sample (and i create database as you), but it doesn't
> work, when i post russian text.


Huuummm ... can you send a sample to my private email using russian text ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] I have problem with russian language

[olegmad <ol...@ya...>]

>I got the same exception as you only when i connect to the database with
>charset that is not the same as the database charset, but i think you
>are doing this ok.
>
>When i use for connect the same charset as the database, has all runs
>fine for me ( in this case UNICODE_FSS ).

I using your code sample (and i create database as you), but it doesn't
work, when i post russian text.

:((

Re: [Firebird-net-provider] I have problem with russian language

[<car...@te...>]

Hello:

> I receive your dll. Thanks again.
> I execute code sample, but problem still exist. I catch same exception 
> with
> same stack trace :(
>
> What can I do, to help you ???

I got the same exception as you only when i connect to the database with 
charset that is not the same as the database charset, but i think you 
are doing this ok.

When i use for connect the same charset as the database, has all runs 
fine for me ( in this case UNICODE_FSS ).





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] I have problem with russian language

[olegmad <ol...@ya...>]

> I have done a change in the GDS implementation for send the subtype for
> char and varchar fields in trh blr description, i want to know if withis
> the sample works for you before make the commit in the CVS (and i want
> to run the nunit test too before commit it :)), can i send to you a
> compiled dll ?? if yes, which version of the .net framework are you using
??

I receive your dll. Thanks again.
I execute code sample, but problem still exist. I catch same exception with
same stack trace :(

What can I do, to help you ???

Re: [Firebird-net-provider] I have problem with russian language

[<car...@te...>]

Hello:

> Yes! :)
>
> i using .net framework 1.1


The email is being rejected, i ave sent it to < oelgmad at yandex.ru >
is this correct email ?? :)




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] I have problem with russian language

[olegmad <ol...@ya...>]

> Don't worry, can you try to debug FbCommand.parseParameters() and see
> what is the encoding being used for each parameter in the line:
>
> Encoding encoding = gdsParams.SqlVar[i].Encoding;

when i = 0; EncodingName = Unicode (UTF-8);
when i = 1; EncodingName = Cyrillic (Windows);