Baza Dannih Zhd Vokzala Delphi

29

янв

Baza Dannih Zhd Vokzala Delphi

Posted: 
Baza Dannih Zhd Vokzala Delphi Rating: 4,9/5 4971 votes
Baza Dannih Zhd Vokzala Delphi

Delphi dbgrid is not showing mysql varchar columns. Ask Question 0. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. I'm using a TDatabase, TQuery, TDatasource and a TDBGrid to connect to the databse with following source.

Acid pro 7 all plugins. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. It happened to me view days ago.

Using dbExpress or Ado connection instead of BDE is not a good idea, because it needs more time to learn and change the code. I use oracle (maybe similiar case with mysql).

Vokzala

You should check your database structure. In Oracle 11, dbgrid cannot display all columns with VARCHAR2 data type and CHAR unit. Dbgrid just display data with BYTE unit. But in Oracle 9i, everything's fine. So, the solution is change the unit ( char to byte).

Airserver windows klyuch. Here is the sql statement for oracle: ALTER TABLE USERX.TABLENAME MODIFY (COLUMNNAME VARCHAR2(50 BYTE)).

Popular Posts

Baza Dannih Zhd Vokzala Delphi

Delphi dbgrid is not showing mysql varchar columns. Ask Question 0. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. I'm using a TDatabase, TQuery, TDatasource and a TDBGrid to connect to the databse with following source.

Acid pro 7 all plugins. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. It happened to me view days ago.

Using dbExpress or Ado connection instead of BDE is not a good idea, because it needs more time to learn and change the code. I use oracle (maybe similiar case with mysql).

Vokzala

You should check your database structure. In Oracle 11, dbgrid cannot display all columns with VARCHAR2 data type and CHAR unit. Dbgrid just display data with BYTE unit. But in Oracle 9i, everything's fine. So, the solution is change the unit ( char to byte).

Airserver windows klyuch. Here is the sql statement for oracle: ALTER TABLE USERX.TABLENAME MODIFY (COLUMNNAME VARCHAR2(50 BYTE)).

...">Baza Dannih Zhd Vokzala Delphi(29.01.2019)
  • Baza Dannih Zhd Vokzala Delphi Rating: 4,9/5 4971 votes
    • Baza Dannih Zhd Vokzala Delphi

    Delphi dbgrid is not showing mysql varchar columns. Ask Question 0. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. I'm using a TDatabase, TQuery, TDatasource and a TDBGrid to connect to the databse with following source.

    Acid pro 7 all plugins. I'm using delphi XE2 and working on a mysql database project. I have a mysql database which has a table consisting of four columns. I have two sample rows in this table. It happened to me view days ago.

    Using dbExpress or Ado connection instead of BDE is not a good idea, because it needs more time to learn and change the code. I use oracle (maybe similiar case with mysql).

    Vokzala

    You should check your database structure. In Oracle 11, dbgrid cannot display all columns with VARCHAR2 data type and CHAR unit. Dbgrid just display data with BYTE unit. But in Oracle 9i, everything's fine. So, the solution is change the unit ( char to byte).

    Airserver windows klyuch. Here is the sql statement for oracle: ALTER TABLE USERX.TABLENAME MODIFY (COLUMNNAME VARCHAR2(50 BYTE)).

    ...">Baza Dannih Zhd Vokzala Delphi(29.01.2019)