[Marko]

peterlaursen wrote on Sep 29 2008, 03:12 PM:

ok marco .. but your message came little too late!

We have started the release cycle for 7.11 with the fixes for the 2 issues you reported here already. Also the focus issue reported by Ritesh will be fixed with this build. Please verify with 7.11. It will probably be avail in no less than 1-2 hours.

Nice, both issues has been fixed. Thank you 🙂

[Marko]

peterlaursen wrote on Sep 26 2008, 02:02 PM:

@marko

We believe we fixed both the issues you reported.

We would like if you could verify on your system before we release for the public.

Please tell if you are COMMUNITY or ENTERPRISE user and we will prepare a special build.

I'm using COMMUNITY build.

[Marko]

I'd suggest you don't remove it, so users still have options, just like selecting charset. You could also hide these option somewhere (Advanced options?). It's your application, you call, but being developer myself, I know people hate it when options get removed, same as people getting annoyed over Gnome as there is always so little options for everything. I also got confused today when suddenly F5 wouldn't execute query anymore…I found out it's F9 now (this should be in tooltip of “Execure Current Query” or somewhere in menu).

But hey, as long as it works one way or another, I'm happy 🙂 Great application, good work guys. I hope someday we'll also see a native Linux version (GTK2 and all)…but that's just my humble wish 🙂

[Marko]

You know what? Setting it to “western” worked 🙂 So thank you for that.

For other question:

– no, I'm never running “set names”.

– Slovenian is the one with “glavna stran”

– data is shown right but stored incorrectly

– attaching some data from mysql (I did “show variables”, hope that's enough) and some dump

[Marko]

SQLyog Community Edition v6.12

I use Windows XP (english). I have my Regional Options set to Slovenian, location to Slovenia, also keyboard and “Language for non-unicode programs”.

I have “central european” set in fonts settings.

[Marko]

1. database (one of them causing these problems) is 4.1.21

2. I mean I set collation to utf8_slovenian_ci to every text field I make

3. I use slovenian language… characters like čšž turn into ???. But if I edit a field and enter some for example “ščižek”, it'll save fine. But when I edit it, I get ??i?ek. The only way to edit fields now is to click on cell, ctrl+c, edit field, ctrl+v and overwrite data and then edit and save. But this is annoying.

All used to work excellent when I could set charset at connection (setting it to cp1250). Would setting DefSrv variable in .ini help?

[Marko]

peterlaursen wrote on Jan 22 2007, 02:25 PM:

BTW: does the file use 'full syntax' like

Code:

`database`.`table`

or

Code:

`table`

only when referencing a table?

Previous question: I was using 1st database for some project, then closed it and clicked on 2nd one, rightclick -> Empty database. it dropped all tables from 2nd database, which is ok. The dropdown on top of program was still showing 2nd database and it way selected in treeview. So I clicked on IMPORT (I imported the SQL) but it used 1st database.

Second: this is part of .SQL I was importing:

Code:

—
— Host: localhost Database: renderspace2
— ——————————————————
— Server version 5.0.22-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

—
— Table structure for table `_contents`
—

DROP TABLE IF EXISTS `_contents`;
CREATE TABLE `_contents` (
`id` int(11) NOT NULL auto_increment,
`id_page` int(11) NOT NULL default '0',
`id_module` int(11) default '0',
`id_module_type` int(11) default '18',
`id_position` int(11) NOT NULL default '0',
`id_state` int(11) default '8',
`lng` varchar(3) collate utf8_slovenian_ci NOT NULL default 'sl',
`title` varchar(255) collate utf8_slovenian_ci NOT NULL,
`ord` int(11) NOT NULL,
`inherit` int(11) NOT NULL default '0',
`lead` text collate utf8_slovenian_ci NOT NULL,
`content` text collate utf8_slovenian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovenian_ci;

—
— Dumping data for table `_contents`
—

etc…

This is the second time this happened to me in last 2 weeks, that's why I reported this. I've used mysqlfront and other programs before sqlyog and this never happened to me before. I can try and reproduce this, but can't do before tomorrow (totaly busy), since I wanna be careful, I have few big and important databases and losing any data would be a disaster 🙂 Will let you know.

[Marko]

No, I thought about that too so I checked, but there is no USE command, just drop/create table commands and inserts.

[Marko]

The only problem I have using this in Linux is encoding…might be Wine issue, but still, I can't enter Latin2 characters when editing data, some can't be entered while others can, but are converted to ? or other weird characters when refreshing. It's kinda annoying, so I need to use phpMyAdmin for entering text. Is anyone experiencing the same problem?

[Author]

Posts