"Laimis" <wiela@centras.lt> wrote in message news:gabbid$3os$1@trimpas.omnitel.net...
> SHOW VARIABLES LIKE 'character%'
> 
> (koks šios komandos rezultatas tiek iš mysql kliento, tiek iš php script'o)
rerzultatas:

character_set_client utf8 
character_set_connection utf8 
character_set_database latin1 
character_set_filesystem binary 
character_set_results utf8 
character_set_server latin1 
character_set_system utf8 
character_sets_dir /usr/share/mysql/charsets/ 


> 
> SHOW CREATE DATABASE 'database_name'
> SHOW CREATE TABLE 'table_name'
> SHOW FULL COLUMNS FROM 'table_name'

CREATE DATABASE `duombaze` /*!40100 DEFAULT CHARACTER SET utf8 */

      CREATE TABLE `customers` (
       `customerID` int(11) NOT NULL auto_increment,
       `Login` varchar(32) NOT NULL,
       `cust_password` varchar(255) NOT NULL default '',
       `Email` varchar(64) default NULL,
       `first_name` varchar(32) default NULL,
       `last_name` varchar(32) default NULL,
        `custgroupID` int(11) default NULL,
       `addressID` int(11) default NULL,
       `reg_datetime` datetime default NULL,
       `CID` int(11) default NULL,
        `ActivationCode` varchar(16) NOT NULL default '',
       PRIMARY KEY  (`customerID`),
       KEY `AFFILIATEID` (`affiliateID`)
      ) ENGINE=MyISAM AUTO_INCREMENT=2412 DEFAULT CHARSET=utf8 


> 
> arba
> 
> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='database_name'
> SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='table_name'
> 
> 
> (koks šių komandų rezultatas iš mysql kliento)
> 


CATALOG_NAME null
DEFAULT_CHARACTER_SET_NAME utf8
DEFAULT_COLLATION_NAME utf8_general_ci
SQL_PATH  NULL