Re: How to convert array to string, and vice versa

Tim Streater said the following on 23/05/2006 17:49:
I have some items, numbered from 0 upwards. Some of them may have a string attached. All these items need to be represented in a single already existing database record. So, I thought of taking an array, as it might be looking thus (the values are all strings):

Key Value
--- -----
0 firstone
2 somestring
5 anotherstr


and so on, and converting it to a single string:

"'0', 'firstone', '2', 'somestring', '5', 'anotherstr'"

then I have a string I can write to the database record.


Is it absolutely mandatory that you put these into a single record? This is almost certainly a bad idea. Not only do you have to write conversion functions to get data into and out of the database, but you data is no longer atomic. Amongst other things, this makes it difficult to search, index, delete or reference your data...


--
Oli
.

Relevant Pages

  • Re: How to convert array to string, and vice versa
    ... and converting it to a single string: ... then I have a string I can write to the database record. ... information about the port optics. ... to have a set of port-records, pointing to the interface card. ...
    (comp.lang.php)
  • Re: How to convert array to string, and vice versa
    ... and converting it to a single string: ... then I have a string I can write to the database record. ... representation is most of the battle and while driving home and back to ... Radio 4 only had an unfunny comedy program last night and a poor ...
    (comp.lang.php)
  • Re: DBI update
    ... > In the following snippet of code, I'm trying to update several fields in a ... > $set, in the prepare statement, is a string that contains field/value pairs ... and save your values in an array rather than a skalar. ...
    (comp.lang.perl.misc)
  • Re: How to convert array to string, and vice versa
    ... Tim Streater wrote: ... All these items need to be represented in a single already existing database record. ... and converting it to a single string: ... I can't see any array or string function that looks designed for this or a similar purpose. ...
    (comp.lang.php)
  • Re: 2D arrays of variable size.
    ... The same argument is true for other simple classes, such as string. ... even the standards folks didn't immediately realize how bad a reference counted string could perform in a MT environment. ... * The overall portability lacks when everyone rolls his or her own, and then we need to provide conversion functions among the various implementations, which is a performance liability. ...
    (microsoft.public.vc.language)