[peterlaursen]

@ritesh

did you consider this discussion in relation to BETA 5 ?

[peterlaursen]

And I suppose that the specified wil be used for

Code:

set character_set_results =

and only that? Just like SQLyog beta4 does?

Now that would actually allow for syncing data between databases having different charset with MySQL 4.1++ when specifying , as the SJA would use utf8 internally and the server would convert charset when storing data as described in defaults or columnn-definitions.

Am I right?

[peterlaursen]

SCHEDULED BATCH EXPORT WIZARD

That is a new name isn't it? :huh:

And what about the 'ordinary' export tool then? 'As is' with MySQL 3-4.0 and uft8 with MySQL 4.1++?

Quote:

When you export from MySQL version less than 4.1, this option does not have any meaning as you cannot export in utf8 with that version.

That was my point too!

[peterlaursen]

😛

I don't think you catched the point exactly!

I was asking: How does the SJA SET NAMES or set_character_results?

I was not asking about tunnelling. I can read the tunneller myself!

I meant “How does the SJA SET NAMES or set_character_results with direct connection?

But I suppose then that that additional TAG will apply to direct connection as well?

(dont forget thatand should each have a charset tag!)

the SET NAMES = {data} – now what is {data}?

show variables like '%character%' returns all those

Code:

character_set_client
character_set_connection
character_set_database
character_set_filesystem
character_set_results
character_set_server
character_set_system

which one is used by the SJA as of now?

Now what about databases having tables using different charsets? Not to speak of 'mixed tables'?

[peterlaursen]

@ritesh: I repeat

There was a question

– and I have seen you at the Forums twice now without bothering to answer it.

How does the SJA SET NAMES or set_character_results ?

How would you expect anyone to beta-test your program if you don't answer their questions?

Will I have to spend 4 hours finding out myself, when you can answer in 30 seconds?

[peterlaursen]

Clarification

Quote:

I think the encoding (ANSI-localisation or UFT8) should be user configurable with MySQL 4.1 ++.

The use of term ANSI here is confusing <_< I would rather say: let user choose between 'save as stored in database' or 'encode and save as utf8'.

[peterlaursen]

I experimented a little with the Paragon Encrypted Disk -program (I have the older version 2)

Now this is funny:

If you place your /datadir on a USB- or an Ethernet drive (or even a CF-card on a card-reader or a USB-stick), MySQL won't start. It is rigorious about the fact that the /datadir must be a LOCAL folder.

However, if I create a VIRTUAL drive with the Paragon software (and now it does not matter if it is on a local drive, an USB drive an Ethernet harddisk or even a Flash-card/a USB-stick) and put the /datadir inside that virtual drive, then I can use that datadir on any external storage with MySQL! Actually not even a 4 GIGA CF-card is very expensive anymore, so this may be quite a usable trick!

Now … that was actually what I have been after before. I have two computers with MySQL installed. I would like them to share the same /datadir (not running at the same time of course) from my Ethernet Harddisk (Just like my mailprogram data are on my Ethernet Harddisk, so that I will always have it accessible no matter which computer I am using). Actually that is possible with MySQL and a Paragon Encrypted (Virtual) Disk.

You also can place the /datadir on a Paragon Encrypted (Virtual) Disk on a Flash-card or a USB-stick (and the best of them are now as fast as a ATA 100 harddisk). Just plug-in, mount the virtual encrypted drive and start MySQL (MySQL should of course not start with Windows then – you configure that from Administrative Tasks .. Services). When you're finished stop MySQL, unplug the FLASH memory, and put it in your pocket or lock it safe somewhere! For 'ordinary' MySQL usage just edit the configuration file and let /datadir point to an ordinary local folder, and restart MySQL. Or you may simply have more MySQL instances configured on each their port.

Actually my Ethernet harddisk has two USB-slots. I can attach a Cardreader to one on those, plug in a CF-card, Create a Paragon Encrypted (Virtual) Disk on the CF-card, mount this Paragon Encrypted (Virtual) Disk with a drive letter in Windows and use it as /datadir with MySQL!

I don't know if other 'Virtual Encrypted Disk' software lets you do this.

[peterlaursen]

With WinXP Proffesional (and 2K I think too) you can use the encryption option that is built-in the NTFS file system. I don't like moving for instance the 'documents and settings' folder to a virtual drive – though I read some tweak-tricks on the Internet that could do it.

But as far as MySQL goes: You may point your /datadir in configuration to any drive – also a virtual encrypted drive. If only it shows up in Windows Explorer.

[peterlaursen]

Hello everyone out there … could I ask for a little bit help here? 😀

I you happen to live somewhere in the world where your Windows localisation is not 'western' – (that is correponding to MySQL latin1) – then

1) create this table:

Code:

CREATE TABLE tt (id bigint, utftext CHAR(20) CHARACTER SET utf8, ucstext CHAR(20) CHARACTER SET ucs2, latintext CHAR(20) CHARACTER SET latin1);

(replace 'latin1' in the last column with a charset that makes sense with your localisation)

2) enter some (10-20) rows of data using your national characters. Also enter table and column comments using your national characters

3) Export the table and attach the exported file here with a screenshot of how it should display!

I think only single-byte character set are interesting at this point of time, but anything is welcome!

[peterlaursen]

Now I tried with this DB:

CREATE TABLE tt (id bigint, utftext CHAR(20) CHARACTER SET utf8, ucstext CHAR(20) CHARACTER SET ucs2, latintext CHAR(20) CHARACTER SET latin1);

to insert some data with special characters (connected with 'set character_set_results = latin1')

Next tried to export 3 different ways:

* With SQLyog (connected with 'set character_set_results = latin1')

* With SQLyog (connected with 'set character_set_results = default')

* With SJA.

The generated files all looked right like

Code:

CREATE TABLE `tt` (
`id` bigint(20) default NULL COMMENT 'æ',
`utftext` char(20) default NULL COMMENT 'ø',
`ucstext` char(20) default NULL COMMENT 'Ã¥',
`latintext` char(20) default NULL COMMENT 'ñ'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='ølhunden æ uiæøiæå';

/*Data for the table `tt` */

insert into `tt` (`id`,`utftext`,`ucstext`,`latintext`) values (NULL,'æ','ø','ø');
insert into `tt` (`id`,`utftext`,`ucstext`,`latintext`) values (NULL,'ølhund','øllebrød','øretæve');

Everything is correct here and all imported correctly.

But I wonder what would happen on my system if there were special characters in the UNICODE columns that are not in the latin1 (ANSI 'western' character) (sub)set?

[peterlaursen]

@ritesh:

There was a question

How does the SJA SET NAMES or set_character_results ?

BTW: just came across this related thing:

http://bugs.mysql.com/bug.php?id=18560

[peterlaursen]

Quote:

but the user name it comes up with isn't one that I have created.

What hvae yo created and what does it come up with? Does the name have national characters in it?

Do you try to connect with SQLog.

What program did you use to create the user?

http://www.webyog.com/faq/23_18_en.html

If it is an account at an ISP you may need to prefix teh user MySQL yuseername with your domain user name.

[peterlaursen]

I wrote the draft for it and the two of us finished it.

The SJA is a much more powerful tool as you would expect at first sight!

[peterlaursen]

Thanks for your comments …

Myself I use the Paragon Encrypted Disk http://www.paragon.ag for such encrypted storage. With it you generate a fixed-size file on your harddisk and that file can be mounted as a virtual drive. Any attemt to open, move, delete this file etc. will promt for the password and/or the encryption key.

[peterlaursen]

Quote:

Then clicked another table to view it, the program just disappeared with no trace.

This issue has allready been reported. I myself has experienced it too. I also know that a crashing bug related to the DATA tab was fixed in the development tree today. I think that exactly how this issue materializes could depend on the hardware configuration and systems settings.

Most likely BETA 5 will be out tomorrow with the fix.

[Author]

Posts