I am working to get my installation of Movable Type Enterprise 1.5 running in China.

Env: Apache Web Server + PHP support on Linux System with Database Server of SQL Server 2005 std on Windows 2003
Webserver env: OS: Cent OS 5.0, Perl: 5.8.8, DBD-ODBC-1.14, DBI-1.58, freetds-0.64, unixODBC-2.2.12


Problem #1: Since MTE 1.5’s SQL Server connection only supports ISO-8859-1 or Shift-JIS encoding, all the Chinese characters entered into the CMS are encoded and the display is like this: &27979;中 etc...

Problem #2: Did a test to connect from our Linux server runing MTE to MTE database created on Windows environment. We found that if we publish contents longer than 144 bytes, the action will fail.

You should probably be talking to your Enterprise contact about this.

I was hoping to solict some information from other folks in my situation. Thanks!

Ah. Well, you're in a pretty small group(Enterprise users) as it is, and then using a database that nobody but that group has access to. I'm pretty sure Enterprise clients are encouraged to just work through their contacts(you paid enough!), as there's generally very little discussion of it in here.

Your first problem appears to just be unsolvable, at least as you state it, and is the primary reason I suggested just talking to your contact. The only way out would appear to be either using another database or getting the issue itself fixed.

I'm honestly not sure I follow the second issue, but assuming that wasn't a typo 144bytes is a ridiculous limit, and just sounds like a bug.