special characters in column names

>Description:
=09I can export Tables from MS Access via ODBC into MySQL
=09whith special characters in column names.
=09(Windows users always use special charakters in every name %-/ )
=09MySQL creates this tables, but I can't realy work whith it.
=09I can't do a select of a row with this strange name.
=09I can dump this table, but can't restore it.
=09This is a general problem when you try to migrate existent
=09Access DBs to MySQL!

>How-To-Repeat:
=09This dump is made with mysqldump, try to restore it.
=09You will find this table (the .MYD .MYI and .frm file)
=09in ftp://ftp.science-computing.de/pub/mysql-bug.tgz

-- MySQL dump 8.22
--
-- Host: localhost Database: test
---------------------------------------------------------
-- Server version=093.23.52

--
-- Table structure for table 'bug'
--

CREATE TABLE bug (
Gesch-Vorz-Exter text,
Gesch-Vorz-EG4 text,
Gesch-Z-Exter text,
Gesch-Z-Jahr int(11) default NULL,
Gesch-Z-EG4 smallint(6) default NULL,
Bezeichnung/Anmerkung mediumtext,
K,VV,19 text,
Datum text,
Art text,
Produktmärkte mediumtext,
Abteilung text,
Amtsblatt text,
Inlandswirk text,
Stellungnahmen tinyint(1) default NULL,
Verweisungsauftraege tinyint(1) default NULL,
2_Phase tinyint(1) default NULL,
Megafusionen tinyint(1) default NULL,
AB1_Fundstelle I-Internet text,
Datum_der_Entsch_Stellnahmen text,
Art der Stellungsnahme text,
Nation text,
Umsatzvolumen text
) TYPE=3DMyISAM;

--
-- Dumping data for table 'bug'
--


INSERT INTO bug VALUES (NULL,'E 4 -',NULL,2000,1,'Anmerkung 1','G',NULL,NUL=
L,NULL,NULL,NULL,NULL,0,0,0,0,NULL,NULL,NULL,NULL,NULL);
INSERT INTO bug VALUES ('MySQL 1','E 4 -','37',2000,2,'Anmerkung 2',NULL,'2=
1.03.2000','6.1.b/Ö','Software','B 6','2000/C 7, S. 5 2000/C 110, S. 45 W=
uW/EU-V 455','I,I/O, AI/O',1,0,0,0,NULL,'25.01.2000','inform.Stellungnahme'=
,NULL,NULL);
INSERT INTO bug VALUES ('MySQL 1','E 4 -','1825',2000,3,'Anmerkung 3',NULL,=
'03.02.2000','6.1.b/Ö','Software','B 5','2000/C 7, S. 4 2000/C 73, S. 4',=
'O',0,0,0,0,NULL,NULL,NULL,NULL,NULL);
INSERT INTO bug VALUES ('MySQL 1','E 4 -','1782',2000,4,'Anmerkung 4',NULL,=
'09.02.2000','Rückn.d.\r\nAnmeld.','Software','B 3','2000/C 7, S. 6','R',=
0,0,0,0,NULL,NULL,NULL,NULL,NULL);
INSERT INTO bug VALUES ('MySQL 1','E 4 -','235',2002,5,'Anmerkung 5','F','2=
5.09.2002','Fehler gefunden','atenbanken','B 1',NULL,NULL,1,0,0,0,NULL,NULL=
,'Bugreport',NULL,NULL);

-- End of dump

>Fix:
=09Don't know %-/.

>Submitter-Id:=09??
>Originator:=09C. Herrmann
>Organization:
science & computing ag
>MySQL support: none (???)
>Synopsis:
>Severity:=09 serious
>Priority:=09 medium
>Category:=09mysql, bug, odbc
>Class: sw-bug
>Release:=09mysql-3.23.52 (FreeBSD port: mysql-server-3.23.52_1)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for portbld-f=
reebsd4.6 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.52
Protocol version=0910
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: =092 hours 9 min 6 sec

Threads: 1 Questions: 7 Slow queries: 0 Opens: 7 Flush tables: 1 Open =
tables: 1 Queries per second avg: 0.001
>Environment:
=09
System: FreeBSD et 4.6-STABLE FreeBSD 4.6-STABLE #2: Sun Aug 18 13:49:55 CE=
ST 2002 hey@et:/net/et/fs1/scratch/system/obj/usr/src/sys/ET i386


Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc =
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC=3D'cc' CFLAGS=3D'-O -pipe -march=3Dpentiumpro' CXX=
=3D'c++' CXXFLAGS=3D'-O -pipe -march=3Dpentiumpro -felide-constructors -fn=
o-rtti -fno-exceptions' LDFLAGS=3D''
LIBC:
-r--r--r-- 1 root wheel 1229498 Aug 16 19:35 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Aug 16 19:35 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 586600 Aug 16 19:35 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=3D/var/db/mysql --without-pe=
rl --without-debug --without-readline --without-bench --with-mit-threads=3D=
no --with-libwrap --with-low-memory '--with-comment=3DFreeBSD port: mysql-s=
erver-3.23.52_1' --program-prefix=3D --with-innodb --enable-assembler --wit=
h-berkeley-db --prefix=3D/usr/local i386-portbld-freebsd4.6 'CFLAGS=3D-O -p=
ipe -march=3Dpentiumpro' CXX=3Dc++ host_alias=3Di386-portbld-freebsd4.6 bui=
ld_alias=3Di386-portbld-freebsd4.6 target_alias=3Di386-portbld-freebsd4.6 C=
C=3Dcc 'CXXFLAGS=3D-O -pipe -march=3Dpentiumpro -felide-constructors -fno-r=
tti -fno-exceptions'
Perl: This is perl, version 5.005_03 built for i386-freebsd


------------------------------------------------------------ ----------
Christoph Herrmann science+computing ag
Beratung und Betreuung Geschaeftsstelle Berlin
Vernetzte Systeme www.science-computing.de

Tel: 030/72623860 E-Mail: C.Herrmann@science-computing.de



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12591@lists.mysql.com
To unsubscribe, e-mail