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 |
|
|
|