True, but what's worst may be the people using it, not the database itself (which really has limitations). It's a forgiving last defense for people that really makes thing last longer before collapsing. Truncating or not the problem is a tiny int ever requiring a 300 insert.
>2: ANSI is error, and abort the inserting transaction. MySQL inserts 'Hell'.
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode..
Thus, worst case is that MySQL inserts 'Hell'... and issues a warning... (which is not the same). If you where to use an older mysql version, you could use TEXT to not have the trailing spaces removed (or use wait for... 5.xx gamma).
NOT NULL means the field can't be empty. If you CHOSE a default value, you meant you wanted the default value.
Example: prefered meal? (default=0)
0 = Did not answer 1 = Pasta 2 = Pizza 3 = Soup
If you don't want that, you just don't use a default value and mysql will complain (warning, or error if you choose so). If you are doing trnsactions (not single inserts) you will be using innoDB or similar, and you can tell the databse to produce and roll back the transaction.
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode.
You do check the data before insert, and do check for warnings afterwards, right?
> What I REALLY need is for the database to pay attention to the constraints I specify. If I didn't care if these fields were blank, I wouldn't have said "NOT NULL".
If you try to store NULL into a column that doesn't take NULL values, an error occurs for single-row INSERT statements. Else, you must be using InnoDB, so that all the changes get rolled back (and one of the latter MySQL versions).
>The only reason that people believe that > they don't have a large impact is because > they don't actually understand the > *reasons* for the correct behaviour.
The reson being neither you nor him knows what theiy are talking about...
From the mysql online reference manual:
The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255.
Values in VARCHAR columns are variable-length strings. In contrast to CHAR, VARCHAR values are stored using only as many characters as are needed, plus one byte to record the length.
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode.
>So, if I try to insert, say, a string of 10 chars into a varchar(9) field, what will it do?
It will do exactly what the datatype says: use 9 fixed chars and add "extra chars" somewhere else. Varchar is to be used when most of the data is >= 9 chars, but some (few) strings are larger than 9 chars.
>What about the whole not-null thing?
This just isn't true. You know, if a field is set to NOT NULL and you don't populate it when you insert a row, MySQL will complain (unless you defined a "default value" for the field.
Too much debt and no credit and no local "trusted currency". The US can avoid this situation easily lowering interest rates. In a crisis, the US lowers interest rates. In small countries like Argentina, you actually raise interest rates in the 25% to 35% a year. If the US has a country risk at 3,5% during a ressesion and another (Argetina?) has a rate of 35%, that's like suddenly having 10 x the nominal debt.
You can only default in such a situation. Argentina at 100 billion dolar debt and 250 billions GDP (before default) would have been fine if they could have lowered taxes (oh, suddently you have lots of money). If the US had to ever pay 35% interest rates, they would colapse the same (would be like having to serve 10x the debt they now have).
In these "speculative attacks", interests raise, and to regain confidence the goverment has to inmediately raise taxes, hoping finantial markets will get reasonable. The end result is a deep recession, taxes that are not enough, and companies getting endebted to death on in massive private defaults. Also, only proyects with a ~40% return on investment are acceptable.
If you really think Rolex and cars will get you the girls you want, just check www.DatingTechniques.net. Note: I have fun on that list and would recommend it to all the timid guys that try to please woman, and then that doesn't work, the try even harder.
Alcohol does not really make people more beautifull, it's main porpuse it to let your fears or worries go for a while.
>Terminal Services is much lighter on bandwidth than VNC
VNC is much lighter on "money" than Terminal Services, VNC has clients for Linux and many other OSs. And if remoting to Linux you just use SSH o plain X.
You can change the theme and the customize the font sizes of everything you see on screen. You should spend 2 o 3 months before deciding. I am using Windows, because that's what we use at work, but I used linux for a large while (and would come back any day). The problem is you spent 6 or more years under something that makes you think differently (a Linux mindset needs more time). If you are happy with Windows, well that's fine, no need to switch then...it's a choice.
Example: i searched for some Casino Salsa content, found a noce site and ordered $120 on dance DVDs. Another example: is someone wants to learn about my company, the can goodle it, and find our website.
I glad they are making money and helping people along the way.
If you don't produce food, you heavily depend on other contries. Food comes before clothes, housing, entertainment, sex and everything else. It's like insurance against "war". Look at it like "National Defense" spending (unless what's being produced is exported).
Thanks for the reply. I understand your points, and agree: the "concept" is great, with Windows some are solved at the wrong place. With Linux it's better able at controling "the user", it's never straight forward. But anything that allows with to better control the infrastructure is great.
Ok, but if you want people to use certain smtp server, force it at the network level, not app level. And why cant people change the homepage? If you have user accounts why not allow them to change it? If it's a public terminal you can make the config file read only to users. Windows does not help much to harden machines, Zen may work, but it's a work arround at best.
>Journalists are accountable to the general public through their credibility
That comes at the cost of always trying to please people, and by people I mean your readers. I found that the best journalists always say what people usually want to hear...
>The irony to this is that I have a healthy dosage of self-control and discipline.
I think that's not true. What you have is a very healthy dosage of profound and deep fear of getting addicted. Self-control is trying it a week and never touching it again for example.
Now, I thought the same as you. I have never smoked marihuana before. I imagined myself in a pathetic stated of addiction that would drive me to somewhere I could never return from.
Now, a year ago I tried it, and it's kind of OK, I never got addicted. I rarely smoke, but I am not afraid. Yes, I don't want to touch anything else. The point is, self control would be to try cocaine for example, and to quit using it after a month even though you really miss it.
You will not be doing it from what I read, and neither will I, but that would be self-control. Me quitting smoking AGAIN would be self-control. I believe not trying something you think is addictive is a choice fostered by profound fear, not by self control. Smoking 1 cigarrete a day, drinking 1 cup of coffee a week, or eating some peyote ocasinally for example would be self control. Fear is no self-control at all, is cowardness.
The problem is your lower price comes from lower prices paid to suppliers. And suppiers means jobs.
That is, your ONLY consideration may be price, but your decision will impact your salary as well. And that not only apllies to wallmat, it apllies to every buying decision.
I will say it only once. The world does not need everyone employed to produce the goods and services that as a society need.
The stuff that poor people buy are produced by large multinationals, the cheaper the work they can buy, the more profits they get, but the less they can sell to the now more poor population. The stuff that the very rich buy are things nobody in africa or poor latinamerica can produce.
Basically, we have built a recurence where the flow of exchange is disturbed. The only way to balance the equation is to empower the poor and middle classes to compete with multinationals. Or to start putting our money where our SALARIES are.
I have this small old Thinkpad iSeries notebook that come with Win98. I installed Slackware and used that for a number of years. Now I am Back On Windows (TM) (Work Notebook) but installed gentoo on the Thinkpad. The problems I had I don't know for sure if they are Gentoo related...
1) After a while (a year?) with Gentoo, the HDD died. It refused to boot anything, and gave tons of errors / halts / madness under Gentoo. Win98 worked fine though... cant remember well. After about 7 month of not using the PC (and booting to check if the HDD problem was still there...) I tryed once again. The HDD (which before made all kind of exitic and espastic noises) wen't ok and booted. I figured how to fix the stuff that got "lost and foound", check the HDD for bad blocks. Everything was fine 100%. So I decide to become up to date. First, the new tree is now huge, and had all kind of resets before a full sucessfull rsync. Can't it just resume (I don't like rsync!)...So everything was going well, after...coreutils! I was lost, no cp, mv or cat command working fine. No df showing any sign of saneness...Lost cause, i did try many think, but NOTHING could compiled on it (remember you need the coreutils). Of course, gentoo wanted to enforce an mtime something, and the network wouldn't boot, and system should not shutdown gracefully. It really showed the Gentoo disadvantages. It WANTED the mtime to be the same, though it could not because of the coreutils or glibc or gcc2.3 fuckup. Finally, I gave up...loaded Win98, transfered Stage 3, boot Gentoo (yuck), untared it, and chrooted. Everything was fine there... so I decided not to rescue the old Gentoo...and after 4 days in this celeron 400 and slow link (64 kbs) I am still compiling gnome... Now, reinstalling Gentoo was a breathe, but I lacked vim, I couldn't find the kernel. And I don't have a burner. So I think it was not an easy setup...Gentoo is not ready yet I believe. I like it, but would NEVER use it in production, or recomend it to anyone that expects something solid (failproof). It's too prune to errors. I wanted to start with x-org, but it wold insist in using both (Xfree + X.Org), so I had to read how to force it to NEVER use XFree the hard way (linking stuff to etc, telling it to slot XFree...) It was a little pain (though not much, I knew what to do, and knew Gentoo). But why am I still on Gentoo? Well, Portage. I don't have time to baby sit a Slackware system anymore (I loved slackware!). I think it has great potential, but need a lot of polish. Sure, it's great when it works, but many times it does not (for example, i had lost a day because some package had a different md5 from a mirror, and while that security is a must, I did lost the compile day). Anyway, I think it's one of the nicest ways to keep a system up to date. Only wishes would be: more testing done before publishing updates that do not work. Less granularity ( I do not want to get cpam duplicated for example!), less "dependancies", even using USE flags gets you much more things than you asked. I told it NO QT and NO KDE, yet the win32 codex downloaded some QT-extras, sigh. And the more important one (maybe it's there an I haven't seen it) DONT FORCE ME TO UPDATE EVERYTHING. If glibc is fine (no holes) or gcc is fine, ask me whether I want to upgrade it or not. I want everything that fixes security bugs, or is a real dependency. Gentoo seems to want to force you to update everything for no reason, adding lots of unnecesary potential trouble for the user...and consuming lots of valuable bandwith (not only mine, but mirror's ones as well). That's it, I said it:-)... I think this is my largest post ever...why? I can't see what I wrote at the begining...remember: I am still compiling gnome and going through Links (at least It was a one liner to get this running...Gentoo has many advantages)! (now that I think, my rant about QT Extras could be QuickTime extras...much relate apropriate than the toolkit...)
You can try one eye at a time if you are so risk averse. The odds of something going wrong are much less than 0.5%. It's less likely that something goes very wrong than having a heart attack due to too much sex.
If you try one eye and then another, you chances of getting 100% blind are 0%. Anyway, the chances of getting 100% even from 1 eye are so amazingly small, they don't really matter.
The cost benefit makes it much less "expensive" if you really have a bad vision.
Slashdot Mirror
True, but what's worst may be the people using it, not the database itself (which really has limitations). It's a forgiving last defense for people that really makes thing last longer before collapsing. Truncating or not the problem is a tiny int ever requiring a 300 insert.
>2: ANSI is error, and abort the inserting transaction. MySQL inserts 'Hell'.
... and issues a warning ... (which is not the same). If you where to use an older mysql version, you could use TEXT to not have the trailing spaces removed (or use wait for ... 5.xx gamma).
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode..
Thus, worst case is that MySQL inserts 'Hell'
NOT NULL means the field can't be empty. If you CHOSE a default value, you meant you wanted the default value.
Example: prefered meal? (default=0)
0 = Did not answer
1 = Pasta
2 = Pizza
3 = Soup
If you don't want that, you just don't use a default value and mysql will complain (warning, or error if you choose so). If you are doing trnsactions (not single inserts) you will be using innoDB or similar, and you can tell the databse to produce and roll back the transaction.
0000-00-00 is a valid date, it's jesus christ's birthdate. :-P
> ... data should not silently truncated.
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode.
You do check the data before insert, and do check for warnings afterwards, right?
> What I REALLY need is for the database to pay attention to the constraints I specify. If I didn't care if these fields were blank, I wouldn't have said "NOT NULL".
If you try to store NULL into a column that doesn't take NULL values, an error occurs for single-row INSERT statements. Else, you must be using InnoDB, so that all the changes get rolled back (and one of the latter MySQL versions).
>The only reason that people believe that
> they don't have a large impact is because
> they don't actually understand the
> *reasons* for the correct behaviour.
The reson being neither you nor him knows what theiy are talking about...
From the mysql online reference manual:
The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value from 0 to 255.
Values in VARCHAR columns are variable-length strings. In contrast to CHAR, VARCHAR values are stored using only as many characters as are needed, plus one byte to record the length.
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. If the truncated characters are not spaces, a warning is generated. You can cause an error to occur rather than an warning by using "strict" SQL mode.
>So, if I try to insert, say, a string of 10 chars into a varchar(9) field, what will it do?
It will do exactly what the datatype says: use 9 fixed chars and add "extra chars" somewhere else. Varchar is to be used when most of the data is >= 9 chars, but some (few) strings are larger than 9 chars.
>What about the whole not-null thing?
This just isn't true. You know, if a field is set to NOT NULL and you don't populate it when you insert a row, MySQL will complain (unless you defined a "default value" for the field.
Too much debt and no credit and no local "trusted currency". The US can avoid this situation easily lowering interest rates. In a crisis, the US lowers interest rates. In small countries like Argentina, you actually raise interest rates in the 25% to 35% a year. If the US has a country risk at 3,5% during a ressesion and another (Argetina?) has a rate of 35%, that's like suddenly having 10 x the nominal debt.
You can only default in such a situation. Argentina at 100 billion dolar debt and 250 billions GDP (before default) would have been fine if they could have lowered taxes (oh, suddently you have lots of money). If the US had to ever pay 35% interest rates, they would colapse the same (would be like having to serve 10x the debt they now have).
In these "speculative attacks", interests raise, and to regain confidence the goverment has to inmediately raise taxes, hoping finantial markets will get reasonable. The end result is a deep recession, taxes that are not enough, and companies getting endebted to death on in massive private defaults. Also, only proyects with a ~40% return on investment are acceptable.
If you really think Rolex and cars will get you the girls you want, just check www.DatingTechniques.net. Note: I have fun on that list and would recommend it to all the timid guys that try to please woman, and then that doesn't work, the try even harder.
Alcohol does not really make people more beautifull, it's main porpuse it to let your fears or worries go for a while.
I thought W2K3 needed a separate license, at least that's what I've been told. Anyway, we agree walking down the stairs is nonsense :-)
>Terminal Services is much lighter on bandwidth than VNC
VNC is much lighter on "money" than Terminal Services, VNC has clients for Linux and many other OSs. And if remoting to Linux you just use SSH o plain X.
You can change the theme and the customize the font sizes of everything you see on screen. You should spend 2 o 3 months before deciding. I am using Windows, because that's what we use at work, but I used linux for a large while (and would come back any day). The problem is you spent 6 or more years under something that makes you think differently (a Linux mindset needs more time). If you are happy with Windows, well that's fine, no need to switch then...it's a choice.
Example: i searched for some Casino Salsa content, found a noce site and ordered $120 on dance DVDs. Another example: is someone wants to learn about my company, the can goodle it, and find our website.
I glad they are making money and helping people along the way.
If you don't produce food, you heavily depend on other contries. Food comes before clothes, housing, entertainment, sex and everything else. It's like insurance against "war". Look at it like "National Defense" spending (unless what's being produced is exported).
Thanks for the reply. I understand your points, and agree: the "concept" is great, with Windows some are solved at the wrong place. With Linux it's better able at controling "the user", it's never straight forward. But anything that allows with to better control the infrastructure is great.
Netscape business was selling apps, Red Hat sells support.
Windows Antivirus Routine Check ....
SYSTEM ALERT! WINDOWS ANTIVIRUS HAS DETECTED CRITICAL TROYAN LINUX_2.6 VARIANT RED_HACK IN YOUR HARD DISK [CLEAN] [DELETE] ?
Now we are ready for the "Windows Antivirus Network Edition"...
Ok, but if you want people to use certain smtp server, force it at the network level, not app level. And why cant people change the homepage? If you have user accounts why not allow them to change it? If it's a public terminal you can make the config file read only to users. Windows does not help much to harden machines, Zen may work, but it's a work arround at best.
>Journalists are accountable to the general public through their credibility
That comes at the cost of always trying to please people, and by people I mean your readers. I found that the best journalists always say what people usually want to hear...
>The irony to this is that I have a healthy dosage of self-control and discipline.
I think that's not true. What you have is a very healthy dosage of profound and deep fear of getting addicted. Self-control is trying it a week and never touching it again for example.
Now, I thought the same as you. I have never smoked marihuana before. I imagined myself in a pathetic stated of addiction that would drive me to somewhere I could never return from.
Now, a year ago I tried it, and it's kind of OK, I never got addicted. I rarely smoke, but I am not afraid. Yes, I don't want to touch anything else. The point is, self control would be to try cocaine for example, and to quit using it after a month even though you really miss it.
You will not be doing it from what I read, and neither will I, but that would be self-control. Me quitting smoking AGAIN would be self-control. I believe not trying something you think is addictive is a choice fostered by profound fear, not by self control. Smoking 1 cigarrete a day, drinking 1 cup of coffee a week, or eating some peyote ocasinally for example would be self control. Fear is no self-control at all, is cowardness.
The problem is your lower price comes from lower prices paid to suppliers. And suppiers means jobs.
That is, your ONLY consideration may be price, but your decision will impact your salary as well. And that not only apllies to wallmat, it apllies to every buying decision.
I will say it only once. The world does not need everyone employed to produce the goods and services that as a society need.
The stuff that poor people buy are produced by large multinationals, the cheaper the work they can buy, the more profits they get, but the less they can sell to the now more poor population. The stuff that the very rich buy are things nobody in africa or poor latinamerica can produce.
Basically, we have built a recurence where the flow of exchange is disturbed. The only way to balance the equation is to empower the poor and middle classes to compete with multinationals. Or to start putting our money where our SALARIES are.
I have this small old Thinkpad iSeries notebook that come with Win98. I installed Slackware and used that for a number of years. Now I am Back On Windows
... cant remember well. After about 7 month of not using the PC (and booting to check if the HDD problem was still there...) I tryed once again. The HDD (which before made all kind of exitic and espastic noises) wen't ok and booted. I figured how to fix the stuff that got "lost and foound", check the HDD for bad blocks. Everything was fine 100%. So I decide to become up to date. First, the new tree is now huge, and had all kind of resets before a full sucessfull rsync. Can't it just resume (I don't like rsync!)...So everything was going well, after ...coreutils! ... so I decided not to rescue the old Gentoo...and after 4 days in this celeron 400 and slow link (64 kbs) I am still compiling gnome... :-) ... I think this is my largest post ever...why? I can't see what I wrote at the begining...remember: I am still compiling gnome and going through Links (at least It was a one liner to get this running...Gentoo has many advantages)! (now that I think, my rant about QT Extras could be QuickTime extras...much relate apropriate than the toolkit...)
(TM) (Work Notebook) but installed gentoo on the Thinkpad. The problems I had I don't know for sure if they are Gentoo related...
1) After a while (a year?) with Gentoo, the HDD died. It refused to boot anything, and gave tons of errors / halts / madness under Gentoo. Win98 worked fine though
I was lost, no cp, mv or cat command working fine. No df showing any sign of saneness...Lost cause, i did try many think, but NOTHING could compiled on it (remember you need the coreutils). Of course, gentoo wanted to enforce an mtime something, and the network wouldn't boot, and system should not shutdown gracefully. It really showed the Gentoo disadvantages. It WANTED the mtime to be the same, though it could not because of the coreutils or glibc or gcc2.3 fuckup.
Finally, I gave up...loaded Win98, transfered Stage 3, boot Gentoo (yuck), untared it, and chrooted. Everything was fine there
Now, reinstalling Gentoo was a breathe, but I lacked vim, I couldn't find the kernel. And I don't have a burner. So I think it was not an easy setup...Gentoo is not ready yet I believe. I like it, but would NEVER use it in production, or recomend it to anyone that expects something solid (failproof). It's too prune to errors. I wanted to start with x-org, but it wold insist in using both (Xfree + X.Org), so I had to read how to force it to NEVER use XFree the hard way (linking stuff to etc, telling it to slot XFree...) It was a little pain (though not much, I knew what to do, and knew Gentoo).
But why am I still on Gentoo? Well, Portage. I don't have time to baby sit a Slackware system anymore (I loved slackware!). I think it has great potential, but need a lot of polish. Sure, it's great when it works, but many times it does not (for example, i had lost a day because some package had a different md5 from a mirror, and while that security is a must, I did lost the compile day).
Anyway, I think it's one of the nicest ways to keep a system up to date. Only wishes would be: more testing done before publishing updates that do not work. Less granularity ( I do not want to get cpam duplicated for example!), less "dependancies", even using USE flags gets you much more things than you asked. I told it NO QT and NO KDE, yet the win32 codex downloaded some QT-extras, sigh. And the more important one (maybe it's there an I haven't seen it) DONT FORCE ME TO UPDATE EVERYTHING. If glibc is fine (no holes) or gcc is fine, ask me whether I want to upgrade it or not. I want everything that fixes security bugs, or is a real dependency. Gentoo seems to want to force you to update everything for no reason, adding lots of unnecesary potential trouble for the user...and consuming lots of valuable bandwith (not only mine, but mirror's ones as well). That's it, I said it
"with our Indian surgeons on par with your Indian surgeons."
Your definetly correct in that one...also, our Chics are as hot as our chics. What a great place to live on here!
You can try one eye at a time if you are so risk averse. The odds of something going wrong are much less than 0.5%. It's less likely that something goes very wrong than having a heart attack due to too much sex.
If you try one eye and then another, you chances of getting 100% blind are 0%. Anyway, the chances of getting 100% even from 1 eye are so amazingly small, they don't really matter.
The cost benefit makes it much less "expensive" if you really have a bad vision.