varchar(250)

[David Rodríguez García]

Hello Andreas

A few days ago you told me about Redefining table iteminfo so I can use bigger items names. I have use:

alter table iteminfo modify name varchar(250);

but I still cant see correctly items names at the left of the page (where the links are place).

I need to see something like that
    - this is the link one
    - this is the link two
    - this is the link three

but I only get
    - this is the li
    - this is the li
    - this is the li

How can I fix it?

Thanks for your help

[Andreas Kansok]

Do you use " in itemnames? Try to use the HTML-code " instead.
And of course you have to enter the long names again after you changed database; but I think that's done ;-)

[David Rodríguez García]

Im afraid it doesnt work. I dont use any quote in itemnames... I have enter the long names again as you thought, but nothing happens...

I can only see 20 caracters of each itemname :-/ but most of them are longer...

What can be wrong?

[David Rodríguez García]

This is the table I get in mysql...

Field    Type    Null    Key    Default    Extra   
-----------------------------------
ID    int(8) unsigned        PRI    nulo    auto_increment
itemID    int(8) unsigned            1   
langID    int(8) unsigned            1   
name    varchar(250)    YES        nulo   
keywords    varchar(50)    YES        nulo   
longdescr    text    YES        nulo   
div0    tinyint(1)    YES        nulo   

[Andreas Kansok]

New idea: Look for 'maxlength=25' into item.php. Maybe the limit for letters is by HTML not MySQL ...

Database looks okay. If you enter a long name directly into databse it works?

[Andreas Kansok]

... or 'maxlength=20' ;-)

[David Rodríguez García]

Thanks Andreas... now Its working. The problem was I must be a little fool... I was working with a wrong table... Sorry ;)

[Andreas Kansok]

... happens ;-)

But you see, there are a lot of possibilities for errors ...