Encoding MySQL Database

[guvenck]

Hello,

I would like to know if there is a way to encode a mysql db like zend encoding a php script?

[ess]

excuse my ignorance...but can you enlighten us as to why you need to do that.

If you are concerned with storing sensitive data, than you should consider using encrypted means to store data.

Encoding data is not really a good way to secure code/data etc. if people (i.e. hackers) are really after your data. Encryption on the other hand is more secure and that is industry standard of securing data anyway.

Don't forget that when you encoding and decoding data...your server slow down as...and it is all a matter of someone figuring out what sort or encoding mechanism you are using....and then they would be able to read it in a matter of minutes

I would recommend that you consider using SSL or TLS to store sensitive data securely. If you don't know about SSL or TLS, please check this URL

http://en.wikipedia.org/wiki/Transport_Layer_Security

Cheers,
Ess

[cash1981]

I think what he means is text encoding right? Like UTF-8 or ISO-8859-1 ??

If you want to do that it is quite easy.

In the console write set names utf8;

Then for each table write this:
create table test (
id varchar(255) not null,
)
engine = InnoDB DEFAULT CHARSET=utf8;

The engine part is optional, but I like InnoDB