#28 text to hex ???

[pcb_nl]

i used CocoaMySQL-v0.7b4

a simple tabel

CREATE TABLE project (
project varchar(50) NOT NULL default '',
jaar year(4) default NULL,
opmerkingen blob,
PRIMARY KEY (project)
) TYPE=MyISAM;

INSERT INTO project VALUES ('Twijnstra & Gudde wandschildering', '2004', 'De wandschildering in het hoofdkantoor van Twijnstra & Gudde te Amersfoort.');

after viewing contents of 'opmerkingen' the text change into

44652077616E64736368696C646572696E6720696E2068657420686F6F66646B616E746F6F722076616E205477696A6E73747261202620477564646520746520416D657273666F6F72742E

this looks like hexadecimal.

i changed the data-type into text and now it works correct.

version 0.5 (v0.5) did not have this problem

thanks,
piet

[Tim H]

Logged In: YES
user_id=683532
Originator: NO

I'm getting the same kind of bug when exporting data.

* With a whole database selected on a remote MySQL database server I ran: File | Export | SQL File...
* left the default options selected: all tables, Add create table, add table contents.
* Saved to the desktop.

The resulting sql file all seemed fine except for the password fields. The data within these fields was wrong.

Here is the original definition for the field (which was correct in the exported sql file also:
CREATE TABLE `ExampleTable` (
...
`password` blob NOT NULL,
...
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is an example of a password field from the exported sql file:
INSERT INTO `ExampleTable`
(...,'6331666537666535653932626130316163663963396463356666306332313734',...)

And here is the original data for that field:
c1fe7fe5e92ba01acf9c9dc5ff0c2174

Regards,
Tim