Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: 22001 Data too long for column


Advanced Search

22001 Data too long for column
Posted by: Jaroslav Pilch ()
Date: October 30, 2005 11:16AM

I am trying to work with MySQL 5.0.15.

In file MY.INI:
[mysql]
default-character-set=cp1250
default-collation=cp1250_czech_cs
[mysqld]
default-character-set=cp1250
default-collation=cp1250_czech_cs

Variables:
character_set_client | cp1250
character_set_connection | cp1250
character_set_database | cp1250
character_set_results | cp1250
character_set_server | cp1250
character_set_system | utf8

collation_connection |cp1250_czech_cs
collation_database |cp1250_czech_cs
collation_server |cp1250_czech_cs

I create database and table:
CREATE TABLE k_nosic (
kod CHAR(5) NOT NULL,
popis VARCHAR(50) NOT NULL,
PRIMARY KEY (kod),
UNIQUE (popis)
);


I want to insert czech chars:
insert into k_nosic (kod, popis) values ('ab', 'ěščřžýáíé');

MySQL connection error: #22001Data too long for column 'popis' at row 1

I've got WindowsXP and I use MySQL Command Line Client.

Options: ReplyQuote


Subject Views Written By Posted
22001 Data too long for column 21417 Jaroslav Pilch 10/30/2005 11:16AM
Re: 22001 Data too long for column 10774 Bence Mészáros 11/09/2005 05:55AM
Re: 22001 Data too long for column 8785 costas costas 11/11/2005 07:12AM
Re: 22001 Data too long for column 9092 Bozidar Rajkovic 12/02/2005 09:50PM
Re: 22001 Data too long for column 6878 fadi mohsen 01/02/2006 03:43PM
Re: 22001 Data too long for column 6223 Thanasarn Kittimethee 01/16/2006 12:56PM
Re: 22001 Data too long for column 5875 huang my 03/14/2006 09:34PM
Re: 22001 Data too long for column 5506 dario parra 08/23/2006 06:24AM
Re: 22001 Data too long for column 5359 Ashwani Kumar 08/17/2007 07:08AM
Re: 22001 Data too long for column 5335 Jack Lin 03/13/2008 10:29AM
Re: 22001 Data too long for column 11577 costas costas 11/12/2005 05:29PM
Re: 22001 Data too long for column 5950 Martin 06/09/2006 03:39AM
Re: 22001 Data too long for column 7849 Umut Ersoy 07/21/2006 07:21AM
Re: 22001 Data too long for column 8666 data data 11/15/2005 01:01AM
Re: 22001 Data too long for column 4410 George Chen 05/01/2006 12:46AM
Re: 22001 Data too long for column 5387 Janos Hajdu 08/18/2006 10:32AM
Re: 22001 Data too long for column 11520 karl.rausing 03/12/2006 10:59AM
Re: 22001 Data too long for column 4706 huang my 03/14/2006 11:34PM
Re: 22001 Data too long for column 3945 thorsten.moeller 04/03/2006 06:54AM
Re: 22001 Data too long for column 8128 stefanov_ss 05/01/2006 10:18PM
Re: 22001 Data too long for column 4775 SAEED SOLTANI 02/13/2007 04:57AM
Re: 22001 Data too long for column 3924 SAEED SOLTANI 02/13/2007 05:18AM
Re: 22001 Data too long for column 4471 jj virus 10/09/2007 02:56AM
Re: 22001 Data too long for column 4664 Tory Hagen 12/03/2007 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.