Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Allowing more chars

Steve2106's profile image Steve2106 posted 2 months ago in General Permalink

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.

1 attachment(s):
  • Tbl-Schema
ansgar's profile image ansgar posted 2 months ago Permalink

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?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.