[peterlaursen]

we will study this!

[peterlaursen]

could you tell what other applications you would typically have running at the same time as SQLyog?

[peterlaursen]

There is no way to change the order.

We will very soon procide a better GUI for exports so that you will be able to 'pick' individual objects. With this you will be able to divide the dump into two.

If you provide a complete structure dump of that database we can look deeper into it!

[peterlaursen]

We will try do reproduce!

If you can provide more specific instruction in how to reproduce then it would be appreciated!

[peterlaursen]

Could you please provide a small table dump with data where this export fails like that?

If ther is a '' sequence in the data they will be considered binary data!

[peterlaursen]

We are analyzing!

In my understanding the situation basically is this:

With unicode (both UCS2/UTF16 and UTF8) there is a one-to-one relationship between the character and the byte pattern representing it.

With ANSI there is no such one-to-one relationship because with characters mapped to the byte values from 128 to 255 also the codepage will need to be specified. I think that Windows font management and keyboard driver interface internally adds a constant for each specific codepage to map characters and the byte values correctly acccording to the codepage. If that does not make sense anymore as program uses UTF8 internally – but causes errors instead – we should remove it from 'preferences'. It it still makes some kind of sense when connected to MySQL 4.0 and before we should keep it – but maybe move it to be a connection-specific setting.

[peterlaursen]

So this 'script' setting should be removed (or at least disabled/ignored when connected to MySQL 4.1 and higher).

We will need to discuss details .. but it definitely is something we have missed till now!

[peterlaursen]

please help!

Which of those is Slovak and which is Slovenian?

http://sk.wikipedia.org/wiki/Hlavná_stránka

http://sl.wikipedia.org/wiki/Glavna_stran

I guess first is Slovak … 😕

[peterlaursen]

Actually the 'script' setting in font 'preferences' is not required with unicode and should probably have been removed from 6.0.

Could you try setting script to 'western' ? I am not sure, but selecting something different may cause the font mapping to 'mess up'!

[peterlaursen]

1) Please confirm that you did not SET NAMES (or SET character_something ..) yourself!

2) Can we have the mysql configuration file (my.ini/my.cnf) ?

3) We should find out if data are STORED correctly and DISPLAYED wrong only. Or if they are STORED incorrectly.

You will only need to export a few rows (containing those characters ) from a resultset and open in Notepad to find out.

4) Could you attach a small dump of a table with such characters so that we have something to work with?

[peterlaursen]

What is the exact SQLyog version?

With MySQL 4.1.21 there should be absolutely no such issue. Everything should be handled fully automatic and transparent.

What language is your Windows?

Are you sure you use fonts (check fonts settings in 'preferences') with central european characters?

[peterlaursen]

BTW: I forgot: you can always see in HISTORY tab what SQL was sent to the server.

[peterlaursen]

You write this:

“I just entered a new user, set his permissions to a certain database, set his permissions on some certain tables within this database, flushed privileges after applying to the changes and hit OK.”

I think you did not do exactly what you aimed to do! Selecting in the Object Browser (the left column) has no effect on user management tools. I could figure that that was what you have been doing (only an idea) ??

In SQLyog you define

*GLOBAL privileges in 'add/edit user'

*OBJECT SPECIFIC privileges in 'manage permissions'

Both are in the tools .. user management menu.

It looks to me that you have defined GLOBAL privileges and not OBJECT SPECIFIC privileges. Or you may have defined both! If user shall have no GLOBAL privileges all checkboxes in 'edit user' for this user shall be empty.

What does

Code:

SHOW GRANTS FOR 'user'@'host';

return?

BTW: no need to 'flush pivileges' explicitly yourself when working from the GUI – the program will do!

[peterlaursen]

Please start reading this FAQ:

http://webyog.com/faq/content/34/148/en/do…y-language.html

SQLyog 6.x uses utf8 internally. For those MySQL versions that support it (>= 4.1) we 'tell' the server to send string data in utf8 encoding. For earlier version we convert inside SQLyog between the C-language types 'char' and 'multibyte'.

MySQL 4.1 and above

******************

With MySQL server 4.1 and above it doesn't not matter how data are stored – the server will still be able to comunicate with a client in a different charset than how data are stored.

Three server variables are in action actually

1) how data are stored in MySQL. The server variables 'characer_set_server' and 'characer_set_database' describe defaults for the server and the active database (latest USE statement), but actually tables and columns may be defined with a different charset

2) What character set is used by the server internally when operating string data. The server variable 'character_set_connection' describes this

3) How data are sent to the client. The server variable 'character_set_client' describes this.

SQLyog will only work with 'character_set_client' set to utf8!

If your server is 4.1 or above you should NEVER 'set names' (or anything like it) yourself! SQLyog and the server 'cooperate' to automatically convert between server and client charsets

MySQL 4.0 and below

******************

Here the server is only able to send data as they are stored! We assume with version 6 that the storage 'matches' the locale of the client machine. In the special situation where a client machine running one locale that does not match stored data in MySQL 4.0 the removal of the selector may have limited posibilities. Anyway we decided to remove because a lot of user did not know how to use that dropdown!

1)

Could you please tell the server version?

2)

I do no understand “I do make tables and fields in utf8 strictly, but DB is still set to Latin1 so all text fields are automaticaly set to this”. If you have defined UTF8 for a table, new columns added will be utf8, but existing columns will have to be changed explicitly one by one. Could you detail?

3)

More details would be appreciated! Screenshots, dumps etc. I know a little bit of Czech, so Czech and Slovak strings and characters I will be able to handle

[peterlaursen]

If you wnat to restore a backup you will need to execute that file from “tools .. restore from SQL dump”.

You can save or copy the file to another location – also a removable media or a network drive.

Try to open the file in a text editor and I think you will understand!

[Author]

Posts