| View previous topic :: View next topic |
| Author |
Message |
nel`chee
Joined: 08 Jul 2004
Posts: 2087
Location: Rijeka
|
 Posted: 18.06.2005 01:52 Post subject: MySQL: varchar/text/blob...? |
  |
|
Googlala sam, no nikako da nadjem neki sajt gdje su tipovi dobro pojasnjeni. Probala sam downloadat manual sa mysql homepage, ali nije htjelo, ne znam jel s moje ili njihove strane nesto puca...
Trebam za svaki item u bazi napisat neki opis, a 255 znakova mi je premalo tako da varchar otpada. Text mi je ipak previse, mislim da to zapisuje do par tisuca znakova, jel? meni bi izmedju 500 i 1000 bilo dovoljno.
Blob nemam pojma sto je, samo znam da postoji, i kad sam jednom prilikom pokusala odredit varchar preko 255 znakova prijavilo mi je error (naravno) i predlozilo da koristim blob.
Savjeti? |
_________________
♥ art & design portfolio ♥ free Photoshop brushes stuff ♥ sketchblog ♥ facebook ♥ |
|
| Back to top |
|
 |
retro_one
Joined: 16 Sep 2003
Posts: 880
Location: DUBRAVA.
|
| Posted: 18.06.2005 01:59 Post subject: |
|
|
BLOB - Binary Large Object - u to mozes spremiti file
tebi treba vjerojatno TINYTEXT (ako se radi o mysql-u) |
_________________
Just your average eccentric programmer. |
|
| Back to top |
|
|
les
Joined: 25 Oct 2004
Posts: 370
|
| Posted: 18.06.2005 02:41 Post subject: |
|
|
| retro_one wrote: | BLOB - Binary Large Object - u to mozes spremiti file
tebi treba vjerojatno TINYTEXT (ako se radi o mysql-u) |
U TINYTEXT stane samo 255 znakova kao i u VARCHAR. Sljedeća "veća" opcija je TEXT - nema ništa "između".... |
|
|
| Back to top |
|
|
nel`chee
Joined: 08 Jul 2004
Posts: 2087
Location: Rijeka
|
| Posted: 18.06.2005 02:56 Post subject: |
|
|
| les wrote: | | U TINYTEXT stane samo 255 znakova kao i u VARCHAR. Sljedeća "veća" opcija je TEXT - nema ništa "između".... |
a ne  pa sta su oni mislili - sta ce im tako mali tinytext kad imaju varchar? bah, bezveze... |
_________________
♥ art & design portfolio ♥ free Photoshop brushes stuff ♥ sketchblog ♥ facebook ♥ |
|
| Back to top |
|
|
retro_one
Joined: 16 Sep 2003
Posts: 880
Location: DUBRAVA.
|
| Posted: 18.06.2005 16:43 Post subject: |
|
|
| les wrote: | | retro_one wrote: | BLOB - Binary Large Object - u to mozes spremiti file
tebi treba vjerojatno TINYTEXT (ako se radi o mysql-u) |
U TINYTEXT stane samo 255 znakova kao i u VARCHAR. Sljedeća "veća" opcija je TEXT - nema ništa "između".... |
vidi fakat...brijao sam da je 2*255, a jebiga  |
_________________
Just your average eccentric programmer. |
|
| Back to top |
|
|
Chaby
Joined: 19 Oct 2003
Posts: 132
Location: VG/ Kurilovec
|
| Posted: 18.06.2005 16:46 Post subject: |
|
|
CHAR( ) A fixed section from 0 to 255 characters long.
VARCHAR( ) A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.
btw. na SQL Serveru je VarChar do 8000 znakova... |
|
|
| Back to top |
|
|
nel`chee
Joined: 08 Jul 2004
Posts: 2087
Location: Rijeka
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Memberlist
Forum ignore list
Register
Profile
Log in to check your private messages
Log in
