Question

I'm hosting my own FogBugz server on a MySql database, and I type a unicode character set (In my case, Russian). Some FogBugz fields, such as case title, are truncating what I enter! What's up?

Answer 1

The full story behind this is rather fun, but ultimately what it comes down to is that we don't use MySql's UTF-8 ability (where present) to represent unicode strings in MySql. This is a workaround that allows FogBugz to work on MySql databases without voiding MySql's 1000-byte index limit.

To Fix This:

1. If you are not hosting FogBugz on a MySql server, you're in the wrong place. Don't proceed to 2. If your FogBugz's database on MySql doesn't have its default character set as latin1, you're in the wrong place. Don't proceed to step 2.

2. Run the following commands on your MySql FogBugz database:

   ALTER TABLE Bug MODIFY sTitle VARCHAR(384);

   ALTER TABLE Bug MODIFY sOriginalTitle VARCHAR(384);

   ALTER TABLE TitleWordWord MODIFY sWord VARCHAR(90);

   ALTER TABLE Word MODIFY sWord VARCHAR(765);

This will fix the truncation for Case Titles. The truncation can still occur in other areas of FogBugz, but in practice, it doesn't. If it's affecting you in an area other than case titles, comment on this answer and I'll modify it with the solution for that area (if a safe one exists).

If you're also having issues with importing email, there's an additional fix to perform.