Citat:
duchess: pa tip podatka mi je nChar(20)
a radim u visual web developer express edition-u (sql).
ne vezano direktno za tvoje pitanje:
1) char i nchar su legacy tipovi i ne treba ih koristiti osim ako SVI (bas SVI) elementi nisu iste duzine, npr postanski broj u srbiji (pa i tad). Za varijabilne stringove koristi varchar(n) i nvarchar(n), gde je n najveca predvidjena duzina stringa.
2) 20 karaktera ti je malo za email adrese
3) email adrese su ascii readable, sto ce reci nema potrebe da koristis unicode tip nchar ili nvarchar, obican varchar radi posao.
Ovo ne odgovara doduse na tvoje pitanje. ako ti svi redovi izbacuju "@email" to mi izgleda kao greska u bindingu ili teksu SQLa (stored procedure)... Daj malo vise detalja, kako ucitavas podatke iz baze i daj tekst SQL-a ili stored procedure...
▪ The quicker a phone is answered in sales, the slower it's answered in customer services - Brownridge's Law
▪ Democracy is a device that ensures we shall be governed no better than we deserve - George Bernard Shaw
▪ To err is human--and to blame it on a computer is even more so - Robert Orben
Registrovani: 89 ( dr ZiDoo, jenki, Laza80, websurfer, ranikolahdd, starkg, Trtko, JCDenton, ctrl alt del, nkrgovic, walkerz, combuster, sipar, gfreeman, ČAPKO, zelja019, devil 2000, rj444, jutikus, igorgaric, Jbyn4e, brasta1, miodrags, Bilfoto, Kovacevic Vladimir, ivantes, vladd, gandalf, samir77, 3okc, S A J A, pitikovski, Cartman, kelja, mmix, guja011, EazyDuzIt, Dario Ristic, mcxxl, Sirenica, smars, pmiroslav, aleksim, Tulex, okram_ca, Nailer, mikiilic, valjan, U.F.O, Panta_, NoneVi, Ivan Dimkovic, dmauka, Nocni, Milan86, Izudar[MTS], PPZ, zoligen, bambuss, x-master, mirko1949, dusanpn, DaliborP, p.tesic, Tyler Durden, NenadS, kargi, dakis, obama, laky007, zarsilic, dejan_m90, kristi1, jericho1405, ikovac, freesoftwareman, kUjKoJa, A.M., deerbeer, maksvel, crveni marsovac, sanja2010, epidemija, legija, bambybg, jugotb, Milos911, mladen mladenov, 93 Stefan )
ZASTO ovoliko zeza grid view