[ic] TIPS AND TRICKS: Tree example

Donal H. interchange-users@interchange.redhat.com
Thu Nov 8 12:55:01 2001


> I bet you are using Postgres, Oracle, or some other DB which pads the
> char() data type. Try changing all field types in tree to varchar()
> and see what happens; or you can add "Database tree ChopBlanks 1"
> to your database config.

Yep - we're using Postgres. I just modifed the perl code that populates the
comb_category column to strip trailing spaces. That did the trick.

Thanks,
-Donal