MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint
Hi Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases?
Re: MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint
Am 07.01.2014 13:48, schrieb Lukas Lehner: Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases? clearly yes the *other direction* may be problematic in case of unsupported features in old version - hence you can even use 3.0 books signature.asc Description: OpenPGP digital signature
Re: loading 0x00A0 into mysql
Hi,
Can you try passing the dump file through hexdump or some binary editor to
see if the data is there. Most text editors will treat 0x00 as end of string
and this most likely this is causing the problem.
Additionally you can try running the import with --default-character-set=utf8
in case the default charset is something else
like this
mysql --default-character-set=utf8 --user=me test_database dump_file
Dobromir
Thanks for the reply, and I apologize because I expect I've broken
threading. The list isn't mailing the posts to me, so I've nothing to
reply to. I've had to cut and paste from the web archive...
2014/01/06 12:18 +, Dave Howorth
Everything appears to work except that text fields containing a
Unicode non-breaking space (0x00A0) are truncated just before that
character. I can see the field in the dump file and it looks OK, but
it doesn't all make it into the new database.
Well, there are too many aspects to this, but the first is the
character set that mysql expects for input. If, say, it is USASCII
(note that between the character set that mysql takes for input and
the character set in the table no association is needful), the nbsp
is out of range.
Hmm, is there any way to tell what character set mysql expects, or
better yet to tell it what to read? Or can I tell mysqldump to encode
its output differently?
(I promise to RTFM, but want to get this question out there whilst I'm
reading!)
(It is, of course, not nice if mysqldump yields an output that
mysql cannot read.)
Indeed; I'd go so far as to call that a bug. But that does seem to be
what's happening.
Try entering it with some escape-sequence (this one is based on the
original SQL with features from PL1, not from C, which MySQL supports
if 'ANSI' is in sql_mode):
I don't understand the 'sql_mode', though I expect I can look that up
too. But I did try these:
'some text ... ' || X'A0' || ' ... more text ...'
causes the contents of the field to be '1'.
or (slightly less PL1)
CONCAT('some text ... ', X'A0', ' ... more text ...')
Produces the same effect as embedding the character directly. i.e. the
value of the field is truncated just before the problem character.
However, substituting for the character with the string 'nbsp;' does
allow mysql to read past it. I've now discovered that it also blows up
on some other characters with the top bit set such as 0x91. What's
strange about that is that they used to work. So my first thought now is
that something has changed recently. Perhaps an update to one of the
servers or clients involved? I don't remember changing anything in my
code, but I can't be absolutely sure.
Cheers, Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ANN: Advanced Data Generator 3.2.0 released
ANN: Advanced Data Generator 3.2.0 released Dear ladies and gentlemen, Upscene Productions is happy to announce the next release of their Windows based flexible and easy to use test data generator tool: Advanced Data Generator 3.2.0 A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, SQL script or CSV files, many filling options, presets and much more. Version 3 included many new features, eg: * Unicode support in an all new fresh user interface * Ability to use external databases as the source for data * New and improved data libraries for real life like data * New template types * Much improved documentation with comprehensive How to-section This product comes in four versions: - Pro: ADO and ODBC connectivity - InterBase Edition - Firebird Edition - MySQL Edition More info and a 30-day trial version on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20140107 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com
Re: Foreign-key reference
2014/01/06 14:24 -0500, Morgan Tocker You might be hitting: Important The inline REFERENCES specifications where the references are defined as part of the column specification are silently ignored. MySQL only accepts REFERENCES clauses defined as part of a separate FOREIGN KEY specification. See: http://dev.mysql.com/doc/refman/5.6/en/alter-table.html Ugh, that seems quite right. Now, why did they do that? A separate specification is less convenient, and also less transparent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has been idle, and right afterwards the client repeats the request and all goes well. The message is no more than an irritatind break between request and fulfillment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Foreign-key reference
Ugh, that seems quite right. Now, why did they do that? It was added for compatibility. A separate specification is less convenient, and also less transparent. Please click affects me on http://bugs.mysql.com/bug.php?id=47771 - Morgan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
regexp in conditional
Can I use an regexp in a conditional? I need to do something like this: SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: regexp in conditional
I think you just have a misplaced parenthesis. try: SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell larry.mart...@gmail.comwrote: Can I use an regexp in a conditional? I need to do something like this: SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Re: regexp in conditional
On 2014-01-07 1:22 PM, Larry Martell wrote: Can I use an regexp in a conditional? I need to do something like this: SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? SELECT IF( r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no' ) FROM s; PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: regexp in conditional
On Tue, Jan 7, 2014 at 12:31 PM, Peter Brawley peter.braw...@earthlink.net wrote: On 2014-01-07 1:22 PM, Larry Martell wrote: Can I use an regexp in a conditional? I need to do something like this: SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? SELECT IF( r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no' ) FROM s; Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: regexp in conditional
On Tue, Jan 7, 2014 at 12:33 PM, Michael Dykman mdyk...@gmail.com wrote: I think you just have a misplaced parenthesis. try: SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; Yes, thanks! On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell larry.mart...@gmail.comwrote: Can I use an regexp in a conditional? I need to do something like this: SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s; I'm getting an error from that. Is there some way to do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
