#mysql
03 October 2007
Total 31 pages. You are browsing page 31/31.
First :: Prev :: [...] [27] [28] [29] [30] [31] :: Next :: Last
23:35 <****> I have a field populated with this example: "086300025/7800231685/012102" when I try to select from where field = that example, I get errors :(
23:35 <****> well.. OLTP is around for a reason
23:36 <****> I assume it has to do with the "/" character.. now what?
23:36 <****> ElDiabolo: you think its that high?
23:36 <****> codestr0m: MySQL 5s query cache is there to help you. Check if the app is using that.
23:36 <****> blobaugh|sp: well I might be 5% wrong :)
23:37 <****> heh
23:37 <****> ElDiabolo: in this cause.. it'll be almost all unique selects.. I'd load the whole damn db into memory if I knew how.. (I'm really not a mysql guru) pointers welcome
23:37 <****> you might be right. ive known only a few non moron programmers. about enough that i dont have to count on my feet actually
23:37 <****> codestr0m: The good news is that the morons don't know bind variables.
23:38 <****> codestr0m: Give it enough key buffer or Innodb buffer cache.
23:38 <****> all myisam tables and I don't know if it would survive being swapped over to innodb
23:39 <****> codestr0m: Set key-buufer-size to the size of all indexes.
23:41 <****> blobaugh|sp: Databases have a long tradition in deploying the work of morons.
23:42 <****> Is it generally useful to use data=journal mode on ext3 for MyISAM?
23:43 <****> Apparently that helps with fsync().
23:50 <****> so if i start a transaction and then abandon it, do i need to do anything special?
23:51 <****> e.g. if i encounter and error and i know i won't be completing the transaction is there something i call that is the same but opposite of commit?
23:51 <****> e.g. cancel?
23:51 <****> how can I find out which character set a database is using?
23:51 <****> using the mysql client
23:51 <****> abstrakt: ROLLBACK
23:52 <****> nevermind
23:52 <****> Marticus: SHOW VARIABLES LIKE '%char%';
23:52 <****> How does one know about transactions and not know about rollback?
23:52 <****> :)
23:52 <****> :)
23:52 <****> thanks, I found it right after I asked
23:52 <****> n8.
23:52 <****> sometimes it takes a while to get an answer in here :)
23:52 <****> guys, how can I concat this: 'select * from' + var + 'where x=1'
23:53 <****> and then run the query ?
23:53 <****> using what?
23:53 <****> procedure?
23:53 <****> over my head, sorry
23:53 <****> cry
23:53 <****> hi all, I have checked my server variables and charset is set to utf8. when I created my db I used charset utf8 and it's default collation. for my table I simply specified engine, and no charset for table or any specific column.. I'm having a problem with a varchar(100) column; it's unable to store 100 unicode characters in it, and I'm not sure why.. from what I gather in the manual mysql should handle up to 100 3-byte characters.. so far
23:53 <****> there are a billion other people on the channel however
23:54 <****> so. anyone knows how to concat a query with a string and then run it inside a procedure?
23:56 <****> by the way, I'm more or less using the same regular expression on w3c to validate utf8 characters... perhaps I'm allowing characters larger than 3-bytes? http://www.w3.org/International/questions/qa-forms-utf-8.en.php
23:57 <****> also, I'm using a multi-byte strlen function to check it's length..
23:57 <****> itnewbie: utf-8 does include 4 byte chars, too. btw
23:58 <****> that must be my problem then? according to the manual mysql only considers up to 3-bytes for each character..
23:58 <****> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
23:58 <****> so I guess I need to figure out where the 3-byte characters end, and only half-way support unicode..?!
23:58 <****> or utf8 rather
23:59 <****> I suspect that "tip" has a typo. I doubt the coders got the max length of utf-8 encoded chars wrong
--- Log closed Thu Oct 04 00:00:35 2007
Total 31 pages. You are browsing page 31/31.
First :: Prev :: [...] [27] [28] [29] [30] [31] :: Next :: Last