[Psi-devel] Forums

[Yves Goergen]

On 11.05.2006 23:02 (+0100), Hal Rottenberg wrote:
> Ok, Yves doesn't know.  :)
> 
> Who knows mysql and unicode stuff who can help me out?
> 
> On 5/11/06, Hal Rottenberg <halr9000 at gmail.com> wrote:
>> Non-ASCII characters didn't import well.  I'm talking to Yves about it now.

Just for everyone's info:
(I assume you're running MySQL 4.0 or older on the old and new machine)
UNB uses no Unicode features of the database but stored everything UTF-8
encoded. Export and import as iso-8859-1 works without problems.

If you have MySQL 4.1 or newer on either machine, you need to set
db_utf8=0 (because we have a pre-4.1 database dump) in the
board.conf.php of that server. Additionally, you need to make the
database import tool manually clear that it must tread the dump as
iso-8859-1 and not UTF-8. And that tool must not make use of MySQL's
Unicode features either. If it does, it will fail. Will, not may.

Now this was the long story. MySQL Unicode is complicated and I don't
like it.

-- 
Yves Goergen "LonelyPixel" <nospam.list at unclassified.de>
http://beta.unclassified.de – My web laboratory.