XML+MySQL+UTF8 = MISERY

[Tereza Snyder]

On Sep 17, 2010, at 12:53 AM, Mark Wieder wrote:

> Tereza-
> 
> Thursday, September 16, 2010, 10:39:01 PM, you wrote:
> 
>> Does anything stand out to those of you who have used MySQL? and revXML? and utf8?
> 
> I haven't used that combination, particularly the utf8 part, but off
> the top of my head, I'd say one problem looks like MySQL is making
> crlf pairs from your cr characters. When you say that you're using an
> insert command to put the data into the database, are you storing it
> as a BLOB?

I'm storing it as mediumtext. I will try BLOBbing it.

t


-- 
Tereza Snyder
Califex Software, Inc.
<www.califexsoftware.com>