KBD

Keith Devens .com

Thursday, September 9, 2010 Flag waving
Couldn't get random quote: Got error 28 from storage engine – MySQL
← The New Criterion — Buckley at the beginningTutorial on Good Lisp Programming Style | Lambda the Ultimate →

Daily link icon Friday, November 4, 2005

Sam Ruby: Sometimes the dragon wins

Sam Ruby: Sometimes the dragon wins. Not here: ɥɦɐ. And you can search for it.

My dirty little secret, however, is that I'm storing everything in MySQL in fields declared to be encoded in latin1, storing UTF-8 in there anyway, and trusting the browser to get Unicode right. I've tried storing everything in Unicode-encoded fields in MySQL, but it mangled some of the rarer characters when I tried to convert this post once my host upgraded to MySQL 4.0 or 4.1 (whichever one first supported Unicode fields). Some characters worked, some didn't. My only guess is that MySQL only handled an older version of Unicode and stripped everything it didn't understand.

← The New Criterion — Buckley at the beginningTutorial on Good Lisp Programming Style | Lambda the Ultimate →

Comments XML gif


Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

  • **bold**, *italic*, _underlined_, --strikeout--
  • "text"="url" creates a link, and URLs are auto-highlighted
  • Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
  • Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
  • Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

:
(will be your IP address if blank)
: (optional)
(Will not be shown on site)

: (optional)
:

September 2010
SunMonTueWedThuFriSat
 1234
567891011
12131415161718
19202122232425
2627282930 



RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
  on 3 posts

Recent comments XML

new⇒Johnny Walker Blue Label

its good to see as many people out​there share the love of johnnie as​i do,...

jared aus - nz: Sep 8, 11:15am

Spider solitaire

 It is a spider solitaire game but​It's not this one, completely​different....

Pat: Sep 5, 9:37pm

Top Ten Bible Versions: Revisited (2010) | This Lamp

NIV is good and reads well but I​always felt like there should be​better. T...

Keith: Sep 5, 4:25pm

Generated in about 0.132s.

(Used 8 db queries)