| 03:12.53 | *** join/#uphpu jakea (~jakea@128.187.221.53) |
| 04:02.27 | *** join/#uphpu drewbono (~andrew@c-24-2-90-131.client.comcast.net) |
| 04:41.56 | *** join/#uphpu drewbono (~andrew@c-24-2-90-131.client.comcast.net) |
| 05:22.04 | drewbono | Hey everybody... |
| 05:22.40 | drewbono | trying to create a table in mysql, and I need large fields that can store a couple thousand characters of text. |
| 05:22.49 | drewbono | I tried blob, but it gives me an error... |
| 05:22.59 | drewbono | is blob the right type for a big field like that? |
| 05:24.43 | drewbono | macnewbold: you there? |
| 05:25.18 | tierra|w | http://dev.mysql.com/doc/mysql/en/storage-requirements.html |
| 05:25.36 | tierra|w | give me another minute, and I can evaluate those sizes, but it's a good reference |
| 05:25.47 | drewbono | tierra|w: thanks |
| 05:27.08 | tierra|w | oh, here's the page I was actually looking for |
| 05:27.08 | tierra|w | http://dev.mysql.com/doc/mysql/en/string-type-overview.html |
| 05:27.11 | tierra|w | much better |
| 05:27.34 | drewbono | bookmark-worthy |
| 05:27.34 | tierra|w | <PROTECTED> |
| 05:27.53 | drewbono | I think the problem was I was putting a value in the length...I guess you're not supposed to do that. |
| 05:27.56 | drewbono | :-) |
| 05:29.15 | tierra|w | yeah, that typically only comes in handy with varchar and types like that |
| 05:30.02 | tierra|w | I like how there's a column type that can hold up to 4GB of data.... heh |
| 05:31.07 | drewbono | Yeah, I use that one _all_ the time. |
| 05:31.16 | tierra|w | hehe |
| 05:31.49 | tierra|w | rowcount() == a few thousand |
| 05:37.36 | *** join/#uphpu wps (~wps@ns2.digis.net) |
| 05:37.39 | *** mode/#uphpu [+o wps] by ChanServ |
| 06:51.39 | *** join/#uphpu tierra|h (~tierra@c-24-10-173-249.client.comcast.net) |
| 07:44.58 | *** join/#uphpu eco (~eco@c-24-10-128-63.client.comcast.net) |
| 10:18.19 | *** join/#uphpu jbot (ibot@apt.bot.TimRiker.active.supporter.pdpc) |
| 10:18.19 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org |
| 14:16.37 | *** join/#uphpu wps (~wps@ns2.digis.net) |
| 14:16.47 | *** mode/#uphpu [+o wps] by ChanServ |
| 14:37.18 | *** join/#uphpu synic (~synic@c-67-172-242-219.client.comcast.net) |
| 15:09.55 | *** join/#uphpu mindjuju (user@207.173.210.167) |
| 15:22.17 | *** join/#uphpu wps (~wps@71.32.228.156) |
| 15:22.21 | *** mode/#uphpu [+o wps] by ChanServ |
| 15:39.46 | *** join/#uphpu drewbono (~andrew@c-24-2-90-131.client.comcast.net) |
| 15:58.56 | *** join/#uphpu tbye (~tbye@64.122.29.10) |
| 16:00.46 | wps | what are these characters called in programming? |
| 16:00.48 | wps | < > |
| 16:08.50 | drewbono | Morning everyone. |
| 16:09.15 | drewbono | I'm trying to update a string in a mysql database, but keep getting errors. I think I'm not escaping it properly. |
| 16:09.18 | drewbono | update faq set answer = 'iMovie is the easiest video-editing software in the world and ships free with every Macintosh. It's one of the applications in <a href\=\"http://www.apple.com/ilife\">Apple's iLife '05 suite</a>. Also included in iLife is software to manage your photos (iPhoto), software to let you listen to and buy music (iTunes), software to let you create hot-looking DVD's (iDVD), and software to let you create your own music |
| 16:09.50 | *** join/#uphpu optikal (~optikal@64.50.125.199) |
| 16:09.57 | drewbono | Any ideas? |
| 16:10.31 | drewbono | The error I get is "ERROR: |
| 16:10.32 | drewbono | Unknown command '\='. |
| 16:10.32 | drewbono | ERROR: |
| 16:10.32 | drewbono | Unknown command '\"'. |
| 16:10.32 | drewbono | ERROR: |
| 16:10.35 | drewbono | Unknown command '\"'. |
| 16:10.37 | drewbono | ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's one of the applications in <a href\=\"http://www.apple.com/il" |
| 16:14.47 | tbye | still there drew? |
| 16:15.14 | tbye | \= is not listed as en escape char from what I see. |
| 16:15.19 | tbye | http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/String_syntax.html |
| 16:16.37 | tbye | You could try to enclose with ` ' |
| 16:16.51 | tbye | Then you won't have to escape quotes either |
| 16:16.55 | *** join/#uphpu usynic (~synic@66.239.17.226.ptr.us.xo.net) |
| 16:30.02 | drewbono | tbye: thanks |
| 16:32.01 | optikal | Morning |
| 17:21.18 | *** join/#uphpu tbye (~tbye@67.51.216.58) |
| 17:46.09 | macnewbold | wps: you get an answer about < and > ? |
| 17:46.21 | wps | nope |
| 17:46.24 | macnewbold | I usually call them "less than" and "greater than" |
| 17:46.36 | macnewbold | but they're usually for redirection |
| 17:46.44 | macnewbold | less than redirects input into a command, |
| 17:46.54 | macnewbold | greater than redirects output from a command [into a file] |
| 17:46.59 | wps | yeah, that is definitely one of their names |
| 17:47.10 | wps | it seems like I have heard another though |
| 17:47.16 | wps | like as they are used for HTML |
| 17:47.19 | macnewbold | then there's pipe, | the vertical bar, that redirects output of one command as input to another command |
| 17:47.20 | wps | for tags |
| 17:47.23 | macnewbold | hmm |
| 17:47.31 | macnewbold | no idea what you'd call them other than that |
| 17:47.41 | macnewbold | the html codes for them are even > and < |
| 17:47.52 | wps | really? |
| 17:47.54 | wps | interesting |
| 17:48.02 | wps | gl and lt it is then |
| 17:49.17 | macnewbold | drewbono: on your mysql quoting thing... one thing that gets me now and then is that in some things, if you wrap your string in single quotes, you can't escape a single quote inside of it |
| 17:49.43 | macnewbold | I think it's sql inserts that get me |
| 17:49.50 | macnewbold | if I do '$val', even with the ' |
| 17:49.57 | macnewbold | slashed on the inside of the value |
| 17:50.01 | macnewbold | it won't work |
| 17:50.12 | macnewbold | but if I do "$val" with slashed quotes inside, it works fine |
| 17:52.10 | macnewbold | html is another one... inside an input tag, you have to escape things with " instead of slashes. |
| 17:58.11 | optikal | sup boys. |
| 18:33.52 | *** join/#uphpu fungus (~fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 19:15.15 | *** join/#uphpu macnewbold (~mac@69.2.248.251) |
| 19:15.19 | *** mode/#uphpu [+o macnewbold] by ChanServ |
| 19:15.33 | macnewbold | did I miss anything? |
| 19:16.43 | usynic | [12:10:25] * macnewbold has quit (Remote closed the connection) |
| 19:16.43 | usynic | [12:15:15] * macnewbold (~mac@69.2.248.251) has joined #uphpu |
| 19:16.53 | usynic | in short, no |
| 19:16.57 | macnewbold | oh, yeah, I knew about that :) |
| 20:20.26 | *** join/#uphpu tierra|w (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 21:04.51 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 21:24.25 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 22:08.33 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 22:59.11 | *** join/#uphpu drewbono (~andrew@byu176783wks.rn.byu.edu) |
| 23:55.40 | macnewbold | quiet day today... |
| 23:55.58 | macnewbold | everybody must have plenty of work, or is outside enjoying the sunshine |
| 23:57.30 | fungus | Unfortunately it is the former in my case. :( |