MySQLCC: Letters disappear

MySQLCC: Letters disappear

am 08.04.2003 12:10:56 von Stephan Matthiesen

Hi,

thanks for the good work with MySQLCC! But...

In MySQLCC 0.9.1., when inserting text that contains foreign characters (e.=
g.=20
German Umlaute), not all the text is inserted into the database.

=46or example when I insert the following into a text or varchar field:
'Häuser is a German word'
the database then contains:
'Häuser is a German wor'

The number of characters lost at the end equals the number of special=20
characters. Perhaps because it is encoded in UTF8 (two bytes for these=20
chars)?

The problem occurs consistently in all databases, all text or varchar field=
s.

The problem did not occur in MySQLCC 0.8.9.

The problem does not occur when inserting text through the command line mys=
ql,=20
or through a Perl script.

My setup:
MySQLCC 0.9.1. Linux glibc2.3 binaries
MySQL 3.23.54 (from RedHat 8.0 distribution)
RedHat Linux 8.0
KDE 3.1.1.

(I don't use MySQL 4.xx yet because the available Perl-DBD-MySQL from RedHa=
t=20
requires libmysqlclient.so.10.0.0).

May I add a suggestion for MySQLCC: It would be enormously helpful if there=
=20
was a "form" view showing a single entry like:
AU: Author
TI: Some interesting article
AB: This is the abstract of the article.
This would be useful for tables with text fields because you can't really s=
ee=20
much in the table view when the fields contain longer text.

Thanks
All the best
Stephan

=2D-=20
Stephan Matthiesen

Institute for Meteorology, University of Edinburgh
James Clerk Maxwell Building, Edinburgh EH9 3JZ, Scotland
Tel: [44]-(0)131-650 5098 - Fax: [44]-(0)131-650 5780
http://www.met.ed.ac.uk/~stephan

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org