At 20/03/2002 01:00 AM, you wrote:

> > 4. Apply any changes that needs to be made to the database
>
>Are you changing THAT table with your program?

Additional information:

I do change a field from varchar(18) to varchar(6) in that table. And, in
one record, the field was bigger than 6 characters.

Here's the process that is used in my code (the syntax might not be
accurate, but gives you an idea):
1. ALTER TABLE tbl ADD TEMP VARCHAR(6) CHARACTER SET UNICODE_FSS
2. UPDATE tbl SET TEMP=field_being_updated
3. ALTER TABLE tbl DROP field_being_updated
4. ALTER TABLE tbl ALTER TEMP TO field_being_updated

The field being updated was created with UNICODE_FSS as well.

Hope gives more indication on what could've happened. As you can see I
don't directly modify the system tables.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)