Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
On 2022-03-01 12:47, Alex Peshkoff via Firebird-devel wrote: On 2/28/22 21:39, Jiří Činčura wrote: Thanks. I suppose not only TPB, but also buffers for batch, events, etc., right? Yes. Basically only DPB and SPB are "UTF8-ready". If one wants everyting to be utf8 why not have appropriate attachment? Having the connection character set UTF8 is IMHO a separate concern from driver/protocol-related communication. The benefits of using UTF8 for driver/protocol communications doesn't always work well with the limitations that UTF8 enforces on the size of (VAR)CHAR columns. If we ever design a new protocol, things like this need to be taken into account. Mark Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
> If one wants everyting to be utf8 why not have appropriate attachment? I agree. Especially in .NET. But people sometimes do crazy combinations. I wish I could drop all charsets and simply use UTF8 only. That would cleanup nice chunks of code. Maybe in couple of years. -- 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] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
On 2/28/22 21:39, Jiří Činčura wrote: Thanks. I suppose not only TPB, but also buffers for batch, events, etc., right? Yes. Basically only DPB and SPB are "UTF8-ready". If one wants everyting to be utf8 why not have appropriate attachment? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
Thanks. I suppose not only TPB, but also buffers for batch, events, etc., right? Basically only DPB and SPB are "UTF8-ready". -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Mon, Feb 28, 2022, at 15:21, Alex Peshkoff via Firebird-devel wrote: > On 2/28/22 13:38, Jiří Činčura wrote: >> Does the isc_dpb_utf8_filename imply also UTF8 strings in TPB (i.e. for >> table names used with isc_tpb_lock_write, etc.)? >> > > They are expected in attachment charset. > > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
On 2/28/22 13:38, Jiří Činčura wrote: Does the isc_dpb_utf8_filename imply also UTF8 strings in TPB (i.e. for table names used with isc_tpb_lock_write, etc.)? They are expected in attachment charset. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
On 2/28/22 13:40, Jiří Činčura wrote: Also, does the isc_dpb_utf8_filename imply UTF8 for database name in i.e. op_attach (not DPB, the name that's before DPB)? Yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
> Also, does the isc_dpb_utf8_filename imply UTF8 for database name in > i.e. op_attach (not DPB, the name that's before DPB)? Obviously it has to. I somewhat thought the DPB contains database name as well. Silly me. -- 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] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
Also, does the isc_dpb_utf8_filename imply UTF8 for database name in i.e. op_attach (not DPB, the name that's before DPB)? -- 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] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
Does the isc_dpb_utf8_filename imply also UTF8 strings in TPB (i.e. for table names used with isc_tpb_lock_write, etc.)? -- 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] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
Jiří Činčura wrote 28.02.2022 11:16: Can somebody explain me how isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename relate to each other. isc_dbp_lc_ctype establish charsert for all data returned from server (unless explicitly overridden in message metadata). isc_dpb_db_charset is default database charset and used only during createDatabase(). isc_dpb_utf8_filename establish charset of DPB items themselves (and database filename obviously). -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename
Hi *, Can somebody explain me how isc_dpb_lc_ctype and isc_dpb_set_db_charset and isc_dpb_utf8_filename relate to each other. In .NET provider these are used somewhat chaotically and I'd like to fix that. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel