I have to store an array in one field of a db. I know how to do that technically. My questions is, which version makes sense to do that.

First a short introduction:
I have categories in a table and need translations for each category for all languages. To start, I have 2 languages (later I will have more). Ok, let's say my category is car and the structure is like that:

```
id    name    translation

```

My first idea was:

```
id    name    translation
1     car     array('eng' => 'car', 'deu' => 'Auto')

```

The second idea was:

```
id    name    translation
1     car     'eng' => 'car', 'deu' => 'Auto'

```

The third idea was:

```
id    name    translation
1     car     'eng'='car','deu'='Auto'

```

At the end, the script reads the translation cell and loads into an array and returns the value for the given key 'eng' or 'deu' or whatever it comes later.

I use PHP / MySQL

Thank you for any pros and cons.

Ivo