1

Topic: To define value RDB$CHARACTER_SET_NAME

Whether probably to define value RDB$CHARACTER_SET_NAME in RDB$DATABASE at basis creation through isc_create_database?
Tried in DPB to place isc_dpb_lc_ctype with value WIN1251, RDB$CHARACTER_SET_NAME remains empty.
Firebird 2.1.7, 3.0.3; win32

2

Re: To define value RDB$CHARACTER_SET_NAME

artemana;
Nightmare what. isc_dpb_lc_ctype it is parameter at a connection already to existing basis.
At creation of basis DB parameters are specified by the text. The example see
http://www.ibase.ru/ibx#ibdatabase
DB creation.

3

Re: To define value RDB$CHARACTER_SET_NAME

;
, and I the core  isc_create_database and isc_dsql_execute_immediate passed that.

4

Re: To define value RDB$CHARACTER_SET_NAME

kdv wrote:

artemana;
Nightmare what. isc_dpb_lc_ctype it is parameter at a connection already to existing basis.
At creation of basis DB parameters are specified by the text. The example see
http://www.ibase.ru/ibx#ibdatabase
DB creation.

IBX here not and, it does not use isc_create_database, and fulfills DB creation through isc_dsql_execute_immediate.
Interests isc_create_database. Yes \is not present. If yes, as.

5

Re: To define value RDB$CHARACTER_SET_NAME

wrote:

The isc_create_database () method is not currently supported from user applications.
It is for internal use only.
Use isc_dsql_execute_immediate () to create a database with a valid database handle.

Read. But it for IB6.0, can that that exchanged.

6

Re: To define value RDB$CHARACTER_SET_NAME

artemana;
At DB creation use isc_dpb_set_db_charset

7

Re: To define value RDB$CHARACTER_SET_NAME

wrote:

2/20/2018 11:26, artemana writes:
> Whether probably to define value RDB$CHARACTER_SET_NAME in RDB$DATABASE at basis creation through isc_create_database?
> Tried in DPB to place isc_dpb_lc_ctype with value WIN1251, RDB$CHARACTER_SET_NAME remains empty.
The isc_create_database () method is not currently supported from user applications.
It is for internal use only.
Use isc_dsql_execute_immediate () to create a database with a valid database handle.

Borland wanted to bury isc_create_database and to force all to use isc_dsql_execute_immediate.
But did not make neither that, nor another. isc_dsql_execute_immediate does not support also half of possible options.
So use isc_create_database, at least with Firebird - anybody is not going to bury it.

8

Re: To define value RDB$CHARACTER_SET_NAME

hvlad wrote:

artemana;
At DB creation use isc_dpb_set_db_charset

Thanks!

9

Re: To define value RDB$CHARACTER_SET_NAME

hvlad wrote:

at DB creation use isc_dpb_set_db_charset

And isc_dpb_lc_ctype it is better to use too thus, differently received as a result
Will have  connection NONE and something can go not so.

10

Re: To define value RDB$CHARACTER_SET_NAME

Dimitry Sibiryakov wrote:

it is passed...
And isc_dpb_lc_ctype it is better to use too thus, differently received as a result
Will have  connection NONE and something can go not so.

Here, by the way, it makes sense to use value set_db_charset for  if it is not set lc_ctype?

11

Re: To define value RDB$CHARACTER_SET_NAME

hvlad wrote:

it makes sense to use value set_db_charset for  if it is not set lc_ctype?

When I last time suggested to use value of one tag for another if that
It is not set, Alex named it "a suspicious feature" so I do not think that it .

12

Re: To define value RDB$CHARACTER_SET_NAME

;
People out of the blue like  to search.   at basis after all can differ from  a connection. So, possibility to specify them separately is necessary. So, at not instructions of one it is impossible to use value from another (because at them a little different assignment).
p.s. To me to spit, as I consider creation of a DB from application senseless  applications. So, though on a head stand :-)

13

Re: To define value RDB$CHARACTER_SET_NAME

;
He hardly meant THIS application.
And that after all Firebird too is possible in an application mode...
smile))

14

Re: To define value RDB$CHARACTER_SET_NAME

kdv wrote:

p.s. To me to spit, as I consider creation of a DB from application senseless  applications. So, though on a head stand :-)

Wrote down in . If in yours application I will see, I will quote.

15

Re: To define value RDB$CHARACTER_SET_NAME

artemana wrote:

Wrote down in . If in yours application I will see, I will quote.

Not . If I already so considered at least 12 years ago when wrote article about IBX...
Especially, I do not write application programs years 17.

16

Re: To define value RDB$CHARACTER_SET_NAME

kdv wrote:

Especially, I do not write application programs years 17.

And here anybody also did not speak about "application-oriented"... wink

17

Re: To define value RDB$CHARACTER_SET_NAME

artemana wrote:

And here anybody also did not speak about "application-oriented"... wink

I meant application-oriented, at me in article about ibx and is written. Instrumental applications can create empty DB everything, somehow, and as much as necessary.