NYCPHP Meetup

[Rolan Yang]

Are you using the --compatible option when mysqldump'ing? It may not be 
documented the man page, but the feature is available.

~Rolan

Rahmin Pavlovic wrote:
> Having a hard time figuring this one out..
>
> We moved a large data store from MySQL 5.0.2-alpha to MySQL 4.1.12
>
> All the high-bit chars -- which were stored fine in MySQL 5 -- are being
> mangled in MySQL 4.  So, for example, if an editor pastes text from MS Word
> or another language, instead of storing the actual characters I get a bunch
> of gobbeldy-gook.
>
> (Unfortunately, 5 isn't up anymore, so I can't compare collation.)
>
> Does anyone have any insight as to what may be going on?  (I had routines
> all up and running to clean high-bit chars that are now choking on their
> mangled equiv.)
>
>
>