[ErikEgon]

Sure, this is what is reported:

 

SQLYog: 12.2.4

MySQL: 5.5.50-0ubuntu0.14.04.1

 

I have seen this behavior more often over the past months (years?), but too lazy to report.

 

Erik.

[ErikEgon]

I've just sent it through the mail. The zip-file is very small: 1,798 bytes.

[ErikEgon]

Sorry, lost the attachment, I think. Another try …

[ErikEgon]

Quote:

BTW: When you wrote “8. In MySQL the data is displayed as mentioned in the first post.” I think you meant “8. In *SQLyog* …” . Right? Did you try other clients?

Yes, SQLyog was what I meant indeed. But I also checked this on the commandline using Putty a few minutes ago and the mysql client tool gives me the exact same results.

I'd be more than happy to share. I think this is an issue that headaches not only me!

Please find attach a zip file containing a very, very basic “index.php” that lets one insert records in a database and immediately displays the results. It also contains the test database containing the table and one example record.

Regards,

Erik.

[ErikEgon]

Peter,

When I dump the table on my local PC the data in the file shows, as you expected, two characters for a simple é.

I thought that telling MySQL it should expect UTF-8 data it would accept and understand multibyte characters and store it as multibyte characters. And apparently, it does.

So I would rather expect that I should create a SQLYog UTF-8 connection so that SQLYog would send UTF-8 data and accept and display UTF-8 data on return.

Stil unsure if this is a situation that has a 100% satisfying answer: perhaps all my wishes just don't mix.

Regards,

Erik.

[ErikEgon]

Hi Peter,

Thank you for responding at such short notice. Still chewing in the information.

Okay, so how do I go about when I need:

1. A website where customers must leave personal data (first and lastnames with extended characters do happen)

2. A database that supports extended characters (I need to store the data)

3. An easy GUI like SQLYog to printout readable data when querying

This is the setup:

1. The webpage (meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″) is in UTF-8.

2. I told the form (accept-charset=”utf-8″) it should send all entered data in UTF-8.

3. I setup the PHP database connection using SET NAMES 'utf8'

4. Created a test database with default characterset utf8

5. Created a table with Character Set = utf8, Collation = utf8_general_ci

6. All varchar columns are in Character Set = utf8, Collation = utf8_general_ci

7. Retrieving previously entered data from the database is correctly displayed, without the help of any PHP function, in the test page.

8. In MySQL the data is displayed as mentioned in the first post.

What is wrong? If you could share any thoughts, it would be much appreciated, not just by me ….

Never thought this was a MySQL bug …

Happy new year!

Erik.

[ErikEgon]

'peterlaursen' wrote:

Not reproducible with this simple test case:

CREATE TABLE k (a VARCHAR(20));

CREATE TABLE l (b VARCHAR(20));

CREATE VIEW m AS SELECT k.a, l.b FROM k,l;

DROP TABLE k;

SHOW CREATE VIEW m;

Also the SQLyog GUI opens as it should from the view context-menu. But of course

SELECT * FROM m;

returns

“Error Code : 1356

View 'test.m' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them”

This reacts (in the GUI, that is) exactly as you predicted.

[ErikEgon]

'peterlaursen' wrote:

And also if you try to show data for the View in the GRID, SQLyog will execute “SHOW FULL FILEDS FROM from `test`.`m`” what returns the same error.

Does not work. Am I looking at a wrongly installed mysql server?

Query : SHOW FULL FILEDS FROM 'vgdagen2011.vw_organisatoren' 





Error Code : 1064


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FILEDS FROM 'vgdagen2011.vw_organisatoren'' at line 1





Execution Time : 00:00:00:000


Transfer Time  : 00:00:00:000


Total Time     : 00:00:00:000

[ErikEgon]

When on the command-line this error appears:

mysql> SHOW CREATE VIEW vw_organisatoren;


ERROR 1356 (HY000): View 'vgdagen2011.vw_organisatoren' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

This error is shown both for the owner of the schema/view and for root. No errors in the errorlogs on /var/log/mysql

[ErikEgon]

'peterlaursen' wrote:

This is a server error (and probably a server bug). All 4-digit error messages starting with '1' are server errors. Just execute SHOW CREATE etc. with any client. You will get exactly the same error.

You are right. I did this on an Ubuntu DEV server, 5.1.41-3ubuntu12.10. When I tried to reproduce this on a UAT environment at the hosting company I did NOT get any errors at all, just when browsing table data. They are using 5.0.90 (not sure what linux flavour they're on).

Sorry for the BUG report. Mistake on my part. I'll have a look with the admin what is causing the error.

Thanks for the quick reply, though!

[Author]

Posts