Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
> Understood - you have inentionally used cyrillic letter code to make > sure firebird accepts it? Yes. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Dimitry Sibiryakov
06.08.2019 11:54, Alex Peshkoff via Firebird-devel wrote: you have inentionally used cyrillic letter code to make sure firebird accepts it? It is UTF-8 code that accidentaly match code of some letter in code page 1251. -- WBR, SD. Firebird-Devel mailing list, web interface at https://

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:48, Jiří Činčura wrote: I see 2 reasons for your last words - you do not catch difference between UTF8 and Unicode, or I completely misunderstand what do you want to say here... Yeah, sorry about that. I was writing the question with assumption that the server will take the UTF

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Dimitry Sibiryakov
06.08.2019 11:48, Jiří Činčura wrote: i.e. CreateFileW can certainly be used. Use of unicode function for file open is the smallest problem on this way. Connection string got destructed way before that. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourcef

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:41, Dimitry Sibiryakov wrote: 06.08.2019 11:36, Alex Peshkoff via Firebird-devel wrote: Why are filenames on windows converted to ANSI, not Unicode? Do not know...   Because Unicode patch was rejected and someone said "we will do it some day in our own way". Can remember who

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
> Why are filenames on windows converted to ANSI, not Unicode? Do not know... I was wondering the same, because i.e. CreateFileW can certainly be used. > I see 2 reasons for your last words - you do not catch difference > between UTF8 and Unicode, or I completely misunderstand what do you want

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Dimitry Sibiryakov
06.08.2019 11:36, Alex Peshkoff via Firebird-devel wrote: Why are filenames on windows converted to ANSI, not Unicode? Do not know... Because Unicode patch was rejected and someone said "we will do it some day in our own way". Can remember who was it? -- WBR, SD. Firebird-Devel mailin

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
> Firebird performs file I/O using the ANSI API (CreateFileA etc), so it > has to convert the input UTF8 string into the system code page before > opening the database file. Learning new stuff every day. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, we

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 12:26, Jiří Činčura wrote: Sooner of all that means that there is UTF8 character which can not be represebted by ANSI codepage on the server. Why it would be converted to ANSI on server? I live(d) years under the impression that the isc_dpb_utf8_filename (and SPB) tells server to

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Dmitry Yemanov
06.08.2019 12:26, Jiří Činčura wrote: Sooner of all that means that there is UTF8 character which can not be represebted by ANSI codepage on the server. Why it would be converted to ANSI on server? I live(d) years under the impression that the isc_dpb_utf8_filename (and SPB) tells server to u

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
> Sooner of all that means that there is UTF8 character which can not be > represebted by ANSI codepage on the server. Why it would be converted to ANSI on server? I live(d) years under the impression that the isc_dpb_utf8_filename (and SPB) tells server to use UTF8 for everything. That would

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 06.08.2019 11:12, Jiří Činčura wrote: And one more question - what happens if you try to access that database using isql? isql freezes (after sending the "connect" statement). But looks like it's a parsing error, because first Ctrl-C gives "CON>" and second "Expected end of statement, encou

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
> Rather hard to deal with non-local international data. (I see different > symbols ona picture and inline in email.) How much symbols was it That's why I included the Unicode code in the email... > expected to have for that 2 bytes - one or two? One. > And one more question - what happens if

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Jiří Činčura
Hmm, when opening regular connection (not services), I get "Cannot transliterate character between character sets" from server and it even does not try to touch the filesystem. The isc_dpb_utf8_filename is included in DPB. BTW same happens if I use Jaybird, but maybe both me and Mark did same mi

Re: [Firebird-devel] И in isc_spb_dbname

2019-08-06 Thread Alex Peshkoff via Firebird-devel
On 05.08.2019 14:26, Jiří Činčura wrote: Hi *, I'm trying to send SPB with И (U+0418) in isc_spb_dbname, but Firebird is comply to do so with "PATH NOT FOUND". With isc_spb_utf8_filename I see firebird process to accessing access img1.png, without it img2.png. Checking the byte array I'm sendi

[Firebird-devel] И in isc_spb_dbname

2019-08-05 Thread Jiří Činčura
Hi *, I'm trying to send SPB with И (U+0418) in isc_spb_dbname, but Firebird is comply to do so with "PATH NOT FOUND". With isc_spb_utf8_filename I see firebird process to accessing access img1.png, without it img2.png. Checking the byte array I'm sending, as a isc_spb_dbname I see { ..., 92, 2