[bass]

thanks!

[bass]

it's all ok, I solved the problem!

Now I can save all special chars into the DB, but I noticed that sqlyog not shows me

all characters correctly! for example I see a “û” instead a long ü, but in the table

it's saved correctly as a long ü! PHP gets it correctly!

does sqlyog have settings about charset for displaying these kind of chars ?

[bass]

sorry for multiposting, but can you show/send me the configuration of your mysql server variables?

[bass]

for info:

..on my machine I see a “?” for every unknown character…

[bass]

I don't now why, but on my machine it doesn't work with this long ü!

With version of MySQL do you use? on witch OS?

[bass]

yes I'm sure, I cannot post it here beacuse the forum doesn't

support these character! it's a “ü”, not with two dots but with

two little lines…

[bass]

yes, but latin1 don't support some hungarian characters, that's the problem!

[bass]

Sorry here is the right URL…

[bass]

…and for CalEvans:

sorry my question but when KEY is the proper SQL Statement….

why I can't found it on mysql documentation?!?!?!?

whats the differences between INDEX and KEY ???

[url=”http://http://www.mysql.com/doc/en/ALTER_TABLE.html”%5Dmysql documentation[/url]

[bass]

…there is the same problem in both ways….

the gernerated sql statement changes the key propertys

for the wrong table… 😉

[bass]

I did it !! That's the problem!

[bass]

when I switch the DB i noticed that sqlyog dislpays

a property of first DB on the second DB window.

and so sqlyog confus the DB's and doesn't the right changes:

sample:

table1 has uniqe key 'key1' (as First Database)

table2 has key 'key1' (as second Database)

sqlyog displays uniqe key on the second DB window !!!

…and so, when I click on “<<< Sync (Clipboard" (I want change key1 of table1 into normal key), it generate: alter table 'db'.'table1' drop key 'key1', add unique key 'key1' ('field1') this generates the same key that table1 had before the alter-query Hope this helps, bass

[bass]

My .sql file is a dump file of a database with over hundered of MyISAM

tables.

It's size is 1.991 KB and it has approximatly 13000 SQL statements.

I loaded the file in the SQL-Editor of both programs and started

the script.

With the Mysql-Front program it took 2min 30sec

with SQLyog the executing process not stoped over 9min…

maybe ther is a bug??

[bass]

Thanx for your software 🙂

[Author]

Posts