Hello,
I am using:
server: Mysql 5.0.16
build 4.0.48eval (waiting to get the full i purchased )

Issue 1: viewing data with utf (or other than latin1) encoding:
SQL:
SET character_set_client =utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;

the variables are correctly set which can be checked by right click on Databases->Details and then tab system.
However when I browse the data i see nontranslated unicode. (Note: table columns are chars, texts not blobs which does not encode, tables transate correctly in other clients.).

Issue 2: silent mode?
When performing query there is no response. It just executes or alerts error. I wish to see results in LOG and in the space under SQL editor (which I thought is for results). And I would omit annoying alerts, but this is just my preference.

Issue 3: select??
select * from table; even use db; select * from table; does not do anything. I expect to find result listed in the window under SQL editor or for what it is there?


SO with mysql 5.0.16 I was able to:
- execute sql with no response except when an error occurs,
- view data with latin1 (probably) regardless the server/client setting,
I was not able to select any data.

Not to be only negative I like structure tab.

other minor issue:
when the sql file line is very long, horizontal scroller will give up too early. Then you need to go with cursor.
(I did not checked SQL syntax highlighting I guess support of many dbs or server settings is not trivial.)

Regarding encoding settings: In Accounts-> database connection could be selection: client encoding.

I would like to hear your experience.
J.

Different charactersets are not supported in DB Explorer.
All strings and characters are treated as symbols from the system's code page.


In future we'll add "Rows affected" status when insert or update or delete are executed.


If you have multiple SQL statements delimited by ";", DB Explorer runs them as batch (like script) and does not spend time for showing the results.
Please use select * from table without ; in the end if you need results.

Sorry, I forgot about semicolumn. It was mentioned somewhere. I can see it now.

Thanks for help ddmitrie.

Purchase advice for others. Don't panic if you don't get answer for several hours.. Eventually you will find confirmation email and "My NuSphere" section in your account.