Ilya,
Actually, I tried entering the data from the mysql client that installs
with the mysql server.
Then, there is no padding. So when I retreive the data, I get only the
data that I entered
manually, and no spaces padded. Also previously I have used mysql
varchar fields with PHP,
and that data is also without spaces. This makes me think that the
problem is probably
something to do with dbi (or the dbd:mysql driver).
Thanks
Jatin
Sterin, Ilya wrote:
>Well if you would look at the mysql documentation, you would notice that
>varchar pads the data with spaces:-)
>
>You can either switch to text data type, s/\s*$//; the paces out of the
>extracted data, or there might be something for DBD::Mysql as there is for
>DBD::Oracle (ora_type => ORA_CHAR), but maybe just SQL_CHAR in bind_param
>will do the job.
>
>Ilya
>
>>-----Original Message-----
>>From: Jatin Nansi [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, July 05, 2001 1:37 AM
>>To: [EMAIL PROTECTED]
>>Subject: Problem with dbi - mysql varchar columns
>>
>>
>>Hello,
>>
>>I am facing a peculiar problem with dbi (1.14) / mysql (3.23.22-beta).
>>whenever i enter data
>>to a varchar column in a mysql table using dbi, there is a lot of spaces
>>suffixed to the data.
>>I think it fills up the column to its total width with spaces. As a
>>result the display of the data
>>using the mysql client is quite terrible, with data getting blanked out.
>>I have no idea what is
>>happening, and this is my first attempt with dbi.
>>
>>Please tell me where could I be going wrong here.
>>
>>Thanks
>>
>>Jatin
>>
>
>
