[peterlaursen]

Sorry .. I do not get you.

I mismathced a “?” and a “+” . Now I edited!

Basically we need to know if the dropdown displays all connections in the .ini or not! Or if they were lost from the .ini.

[peterlaursen]

Sorry for the delay.

I think in 3 weeks we will support VIEWS in Query Builder and Schema Designer.

[peterlaursen]

Please open the file in a text editor.

Does the content of the file 'match what the program displays?

[peterlaursen]

1) To change the default for a table do ALTER TABLE .. advanced and select the charset and collation

2) To change the default for a database (once it is created) you will have to execute the SQL like

Code:

ALTER DATABASE charset ;

A GUI option in the database menu will be added soon!

NOTE: defaults will only have effect on new 'lower-level' objects added after that! Existing 'lower-level' objects will keep their old defaults.

3) To change the encoding of existing columns that are still empty just change the charset for every string column in ALTER TABLE

4) To change the encoding of existing columns with data you will have to do as described here

http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html

Quote:

… what you need to do is to perform changes using ALTER TABLE in two operations like:

varchar >> varbinary (or BLO:cool: >> varchar (and similar for char and TEXT types).

This you will have to do on every exisiting string column in every table.

[peterlaursen]

Please always tell the SQLyog version and the MySQL server version!

Full/exact versions, please!

It is not possible to reply to this question without that information!

Bu as I understand you write greek encoding to datbase tables defined as latin1!? Why do you store greek data in tables defined with latin1 charset (if that is what you do)? With SQLyog 6.1x you can easily define 'iso-8859-7' as database and/or table default! What is the column-level charset setting for strings? If also colums are defined as latin 1 but you store anotehr encoding neitehr the server nor the client will know how to handle those data!

Please refer to: http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html

One more thing you should know is that you shall never SET NAMES yourself when connected with SQLyog 6.0.

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

[peterlaursen]

13: Ok – we will try seriously again tomorrow!

[peterlaursen]

You are right about the speed. It is not quite as fast as 5.x. Hopefully we can improve furher!

[peterlaursen]

I am afraid I still either cannot reproduce this or do not understand!

Quote:

if you leave your mouse over the pulldown input box after clicking to open it, and then navigate with keystrokes, but use the mouse button to click and choose the selected entry whose name has been auto-entered into the input field because of keystroke navigation. After clicking, the displayed name updates, but all the fields in the rest of the dialog box do not.

can you detail ..

[peterlaursen]

If you in 'advanced' options decide to import into existing database/tables you will be able to map a source column to a target column and the definition for that column will be usded

I think we will need an example (an empty access database and a structure-only MySQL dump) It we whall be able to deeper into details!

[peterlaursen]

This

Quote:

– – the rest of the fields in the dialog box DO NOT update. They just keep their existing content

– – If you click Connect, it connects using the old data

– – The name of the selected connection in the pulldown menu gets saved as selected when exiting the program

is not reproducable for me with 6.13. It 'fills out' with the correct data for the named connection and connects with it.

Any idea?

What exact version do you use?

[peterlaursen]

It should map automatically if the structure is identical in source and the target MySQL database that you specify.

Are table names identical in source and target?

[peterlaursen]

Issues were adressed in 6.13 that was just released.

We are very sorry for this of course.

[peterlaursen]

1) confirmed that empty lines will cause stop reading from the file

2) also speed issue with huge number of connection is confirmed

[peterlaursen]

Except for compressed image files (jpg, gif, png) and very small .txt's we request that you zip attachments.

There are two reasons for the limtation:

1) protect users against downloading and accidentially executing files with any kind of active content

2) save disk space on the server

I do not understand 'Please remove the .xml additional extension' .. from where?

we will return the 'original matter' soon,

[peterlaursen]

we will check everything in detail when office opens in 4-5 hours

[Author]

Posts