apostrophe is written db as '

Questions › apostrophe is written db as '
0 Vote Up Vote Down
santosh asked 7 years ago

Hi,

When I am updating a varchar(43) field with collation latin1_swedish_ci
the apostrophe is written db as '
How do I avoid this?

3 Answers
0 Vote Up Vote Down
Abu Ghufran answered 7 years ago

I am unable to generate this case.
If you are facing this issue with html editor, then it is expected behavior.

0 Vote Up Vote Down
santosh answered 7 years ago

Hi,

this is happening when I am editing a record by double clicking and saving. I am seeing this problem when any special character is entered. Is there any way to avoid this?

0 Vote Up Vote Down
Abu Ghufran answered 7 years ago

Hello Santosh,

Can you send screenshots to regenerate this issue?
Also send me code and test data.

You can email me at [email protected]

Your Answer

3 + 9 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.


How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?