MySQL Binary

[Mystery]

Not sure where to post this.. but I have a simple question people might know and I don't.. In a MySQL table, you can add a BIN column also known as a Binary column. I was just wondering, how exactly can you translate simple text to binary so that the MySQL Table reads it? I've tried uploading .bin files, etc. but I can't seem to get it to work.

[Mystery]

Anyone know?

[Brian]

In PHP you can use addslashes with fread to convert a binary file into a string of characters that can be used in a SQL query to insert the binary file.

[Mystery]

Yeah uh.. I have no idea how to set that up o_o... Im not really a wizard when it comes to PHP.. (Complicated codes).

Edited May 28, 2012 by Mysterious

[Mystery]

Could you help elaborate a little further on how should I do those Brian? :/

[Brian]

I think something like this: http://tournasdimitrios1.wordpress.com/2010/09/17/storing-binary-data-in-mysql-databases-with-php/

[Mystery]

Thanks!! It seems promising so I'll try it out! Thanks a lot Brian!

Damn, I don't know how to add it to a specific column.. because what I have is an item_db but theres a description field that's in a binary field.

Basically, this is the structure of the table:

(`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `attack`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`, `Description`, `Description_IRO`, `Episode_Info`, `Droppers`)

`Description` is the Blob field.

Edited May 31, 2012 by Mysterious

[Brian]

What data are you storing in `Description` ?

If it's text, I think CHAR or VARCHAR data type would be better, or if it's longer then TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT.

http://dev.mysql.com/doc/refman/5.5/en/blob.html