|
Тема |
Re: Ако Монти беше българин ... [re: salle] |
|
Автор | user (Нерегистриран) | |
Публикувано | 05.10.05 18:00 |
|
|
mysql> select version();
+---------------------+
| version() |
+---------------------+
| 4.1.14-Debian_6-log |
+---------------------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'char%' ;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character_set_database | cp1251 |
| character_set_results | cp1251 |
| character_set_server | cp1251 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)
mysql> show create database test;
+----------+-----------------------------------------------------------------+
| Database | Create Database |
+----------+-----------------------------------------------------------------+
| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET cp1251 */ |
+----------+-----------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> create table янч (
янс INT(11) default NULL auto_increment,
s CHAR(60) default NULL,
ях ENUM('123', '234', 'спряно'),
PRIMARY KEY (янс) ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> describe янч;
+-------+------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+---------+----------------+
| янс | int(11) | | PRI | NULL | auto_increment |
| s | char(60) | YES | | NULL | |
| ях | enum('123','234','спр','но') | YES | | NULL | |
+-------+------------------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
Дайте идея защо 'спряно' се превръща в 'спр' и 'но'
|
| |
|
|
|