Several months ago, I jumped in head first and moved my site from one server to a better one. Being pretty inexperienced, it took me some time, and some help from good people here. Here's the thread: Importing UBB Threads ...to UBB Threads

It was all moved and things looked ok, so I threw the switch and started running on the new site.

THEN I discovered a terrible problem with the Import. I documented it in the last two posts of the "Importing" thread. But it took me several weeks to clean up the problem with some manual editing of hundreds of posts.

I discovered that EVERY odd ascii character caused the imported message to truncate at that character! Here's a list of the characters I found to cause a problem. I am sure many others would too, but these are ones used in posts on my site:
Code
ch.  hex    Description
--  ----  ---------------
…   \x85  ellipsis
‘   \x91  left curly apostrophe
’   \x92  right curly apostrophe
“   \x93  left curly doublequote
”   \x94  right curly doublequote
•   \x95  imported bullets ( not [list] ubb code )
–   \x96  longer dash
—   \x97  longest dash
™   \x99  TM
¢   \xa2  cents
­   \xad  another dash
®   \xae  registered or TM
°   \xb0  degree symbol
·   \xb7  small bullet
½   \xbd  1/2
¾   \xbe  3/4
ä   \xe4  Bärtsch (a last name)
é   \xe9  café
I checked the posts and found that it was ONLY the text in the POST_BODY column was truncated. All other columns in the SQL Insert statement into the ubbt_POSTS table were fully inserted into the new database.

In my "Importing" thread, nobody responded to this problem report, so I thought I'd bring it up again. If anyone copies this post into their forum, and then tries to do a backup followed by a restore or Import of it, I'll bet the post will be truncated at that first ellipsis character above.

And I know there are lots of forums running in European languages, so I am curious how bad this problem is.

Or is there simply a character-set problem between my my laptop (where the import files are) and the new server??? The import files contain the full messages -- that is where I picked up the text of the broken posts.

WhitneyZone -- Whitney Hikers Association