' Not Managed In Fields Comments (4.2rc1)

[shoyu]

Hello,

This is a bug with V4.2RC1:

Problem:

It seems that special SQL characters like ' are not managed in the comment column of the “alter table…”.

If you type Nombre d'années (french) you have an error when you validate.

Solution for the moment: You have to type Nombre d''années.

Cheers.

Shoyu

[peterlaursen]

@shoyu

Or you could write Nombre d'années – as you would do in handwritten SQL according to the general rules of using escape characters within strings. But yes I think that I remember that you can escape ' with one more ' too. 🙂

But we agree SQLyog should handle escaping automatically here as anywhere else …

The point/explanation is that SQLyog encloses all string with the ' character when building SQL, so

Code:

Nombre d'années

becomes

Code:

'Nombre d'années'

becomes in the ALTER TABLE staement after being 'processed by SQLyog. Thus the string is only

Code:

Nombre d

and

Code:

années'

is garbage! And MySQL raises an error.

[Ritesh]

shoyu wrote on Oct 26 2005, 10:16 AM:

Hello,

This is a bug with V4.2RC1:

Problem:

It seems that special SQL characters like ' are not managed in the comment column of the “alter table…”.

If you type Nombre d'années (french) you have an error when you validate.

Solution for the moment: You have to type Nombre d''années.

Cheers.

Shoyu

[post=”7705″]<{POST_SNAPBACK}>[/post]

This is correct. You will need to escape ' with a .

[Author]

Posts