|
|
|
|
Joined: Jan 2003
Posts: 338
Enthusiast
|
|
Enthusiast
Joined: Jan 2003
Posts: 338 |
I want to know how long "varchar" has this element of mysql table. And if I change wight of G_Smiley, what will be?
My trouble this that VarChar has 10 long value, but I want to change it for 20...
|
|
|
|
|
Joined: Dec 2000
Posts: 1,471
Addict
|
|
Addict
Joined: Dec 2000
Posts: 1,471 |
255 is the maximum, if i remember correctly.
20 will work for sure.
|
|
|
|
|
Joined: Jan 2003
Posts: 338
Enthusiast
|
|
Enthusiast
Joined: Jan 2003
Posts: 338 |
thx  But this is not working correctly, I changed it for 20, but it displays 10 value so far...  I tried to change it in my PhpMyAdmin
|
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
What's the output from this query?
SHOW COLUMNS FROM w3t_Graemlins
|
|
|
|
|
Joined: Jan 2003
Posts: 338
Enthusiast
|
|
Enthusiast
Joined: Jan 2003
Posts: 338 |
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
It's still varchar(10).  Do you get an error when you try to change it to 20? Does your DB user have permissions to alter tables?
|
|
|
|
|
Joined: Jan 2003
Posts: 338
Enthusiast
|
|
Enthusiast
Joined: Jan 2003
Posts: 338 |
when I'm trying to change it program displays "table w3t_Graemlins has been altered." without any errors, but still I have 10 value.
|
|
|
|
|
Joined: Apr 2003
Posts: 31
User
|
|
User
Joined: Apr 2003
Posts: 31 |
Try creating your own script to connect to the DB and give the ALTER TABLE command.
|
|
|
|
|
Joined: May 2003
Posts: 5
Newbie
|
|
Newbie
Joined: May 2003
Posts: 5 |
Have you ever coded with UBB.Threads?
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Are you guys seeing who responds to the oldest threadx here? You've got a ways to go 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 87
Joined: December 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
