[peterlaursen]

Could you be more specific in describing what you want ? 😉

Sqlyog can work with tables where charset is UTF8. In my language (Danish) there are three special characters written Æ , Ø and Ã… (hope they display correctly in browsers around the world!) and they display correctly in Sqlyog with the “latin1” as well as the “uft8” charset as the charset for the table containing the data.

I have a lot of data with text strings from German, Swedish, Spanish, Portuguese and more languages that all contain special characters, and no problems. But admittedly – they are all based on latin.

Charset is a pr. table setting with the MySQL server. Do you want to choose uft8 as charset for a table with CREATE_TABLE and ALTER_TABLE from the sqlyog GUI even if it is not default server setting?

Or is it the Sqlyog GUI itself that should be using utf8 ? Please be more specific!

[peterlaursen]

I agree there is a problem. I have experienced that too recently. Not every time but from time tt tome.

However it should work to click on the DB in the Object Browser (or choose from the drown down as you do – I think it does exactly the same).

In my case it has always been possible to solve the problem to close sqlyog at start it again. But of course that's not perfect …

[peterlaursen]

Is the server configuration under your control ?

It could be a problem with the value of the MAX-ALLOWED_PACKET variable in the MySQL server configuration file (my.cnf/my.ini) being too small.

[peterlaursen]

It won't make much sense to discuss the correct meaning of a word. But I actually just checked a few high quality english dictionaries and found no definition like yours. The original meaning of the word relates to TIME and SPEED only (The word “synkron” is originally greek and means “at the same time”) and there is in my opinion no autoritative meaning of the word when referring to DATA.

The problem is I think,

1) that records can be deleted from one server ON PURPOSE. In that case syncronisation should also delete that record on the other server. So when there is a record existing on one server and there is no corresponding record on the other, there is no way for a computer to tell if it is because one has been deleted or if one has been added!

2) and when originally identical data have been changed at both servers while hey have been disconnected no computer can tell either, which of the two updates are the “right one”.

I might be possible to have an option added like “keep records from both servers”, so that when records with identical keys but different content are met, a new record is created at the server. But that would make the syncronisation tool VERY slow, because it would have to compare every bit of data and not only an index. And could in case 2) erroneously create two records where there should only be one!

So what are your practical needs? There might be more options that can be built in the program, workarounds for common situations …

[peterlaursen]

How you can know ???

If what you have is a BETA and the one available for download is NOT a BETA …. do I need to continue ? 😀

But you're right in that respect, that it seems like Ritesh forgot to update this information:

http://www.webyog.com/forums/index.php?act…t=ST&f=2&t=1301

[peterlaursen]

I'm sorry …

'twas the wrong place I posted this 🙁

[peterlaursen]

Personally I don't have any needs at the moment.

But I think at least it should support more pic formats (new formats arising (espec. 48 bit formats) due to development in digital photograpy)

There was also the request to display the binary data as what they are: binary data!

But I don't think you guys at webyog should spent a lot of time with writing code for more formats. I proposed instead a plug-in model and/or a possibility to launch an external application and save data transparently back to the base …

[peterlaursen]

the .php subsystem may be down on the server.

Try renaming any .htm or .html file to php and see if you can access it!

If you have not used php before maybe you should use the configuration tool available at your ISP to enable the php-interpreter on the server for files with the .php file extension.

[peterlaursen]

I thought I posted a reply here .. but obviously I didn't …

There could be a setting “keep user settings of column width's” just as there alreadys is “truncate header …” and it should would with all queries!

Preferably the settings should be saved ….

[peterlaursen]

And I did 5.0.3 this morning and just tested again with the brand new 5.0.4 and still no probems!

[peterlaursen]

I second that …

Particularly if you have long varchars you may choose not to show everything in each field in order to get room for all fields (or just the important fields) on the screen.

So I think there should be a setting “Keep user settings for column width's” alongside the existing setting “truncate column headers to max data size). It should work not only when sorting, but with all queries …

It's now without problems implementing that however – especially if it is a request that the setting should be saved when the application is closed. I'd prefer then, that the settings be stored in the MySQL database itself rather than an .ini file. However when connecting to a remote host (and you don't have a local installation of MySQL) you might not have privileges for that!

[peterlaursen]

yes .. a proposal …

could be

BLOB (empty)

BLOB (data)

In case the viewer can recognize the data format the type of data could be displayed like

BLOB (filetype) – if the filetype can be identified by the viever

ie:

BLOB (jpg)

BLOB (txt)

BLOB (wav)

probably “repainting” the buttons here should run in a seperat thread not to slow down things …

For the more than two years I've been using Sqlyog the BLOB viewer has not been updated. I think it's about time to do something about that. The release of 4.1 must be first priority – control features for the new stuff in MySQL 5.0.x (stored procedures and adhancements to user management first of all) second priority (I guess that is the main issue with 4.2 – right ? )

– but what comes after that ??

Here was another request concerning the BLOB viewer

http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1337

… where I also had some comments.

[peterlaursen]

What is the MySQL server version ?

[peterlaursen]

Well .. database names, user names, passwords and privileges are in the MySQL database itself (as you probably would know).

I don't see why you'll need to be able to log on as every user with sqlyog. You can create ONE user and give that user any set of privileges that you need to all bases (if they are on the same server). There is also the server's ROOT user available.

But the answer to your question: importing from a text-file: No!

[peterlaursen]

I had a private messegae from you with the content

“Report:

Will Webyog 4.1 support scheduled odbc import ? Your answer was misleading.”

First:

I don't think it is misleading! Scheduled odbc import is still planned for 4.1, but 4.1 has been postponed. What's misleading about that ?

Second:

Why don't you continue the discussion in the forum ? I'm just an end user of sqlyog devoted to spending some time with forum and test beta-versions of the program. I don't have more influence on future development than anybody else.

[Author]

Posts