Allowing more chars

Hi There,

I have a table declared as shown in the attachment. The field "certname" has a length of 100 but when I try to add a value of more than 20 chars it throws an error. Does anyone know why?

Thanks for your help.

Best Regards,

Steve.

Sounds strange. I just looked up the VARCHAR definition, and it says that you define the number of charactes, not bytes. So in your case you should be able to use 100 characters, anyway if these are multi-byte or single-byte characters.

What does the error message say exactly?