Author Topic: "Customer note" textarea saves ASCII characters in database  (Read 334 times)

serazoo

  • Beginner
  • *
  • Posts: 33
"Customer note" textarea saves ASCII characters in database
« on: January 20, 2021, 03:51:00 am »
Hello VM community :)

I'm using Joomla 3.9.23 and VirtueMart 3.8.6 10373
The database table structure is in UTF-8
In VM config "invoice/email" I've chosen the font "Free mono (UTF-8 Unicode)"
But the same 3 ASCII characters are saved in many "customer notes" in database

I've read a couple of posts a str_replace is an option for replacing those ASCII
Is there a way to intercept them and replace, before they get saved to DB?

&#13 : return
&#10 : line Feed (Lf)
&#39 : apostrophe '

The "Return" and "Line feed" can be relpaced by a space
How to formulate a script ? In what file and where to insert it?
Thank you for your time :)

I found  :-\
<h3><?php ($this->keyword = vRequest::uword ('keyword', "", ' ,#39,-,+,.,_,#,/')); ?></h3>
$name = str_replace('&#39;', ' ', $product->product_name);

serazoo

  • Beginner
  • *
  • Posts: 33
Re: "Customer note" textarea saves ASCII characters in database
« Reply #1 on: February 22, 2021, 02:55:42 am »
GJC Web Design, a VM contributer hinted this could be keyboard related. A couple of posts years ago, here in the Forum had the same issue using French language, LIKE ME!

The question is : how does VM handle keyboard and language differently than Joomla?

-All Joomla inputs with an apostrophe ' are fine in Database
-All VM inputs : child products, person's name and customer's note in cart... apostrophe '  result with an ASCII code &#39  in database

Can someone please shed a light on this?
I'm sure a fix can help many foreign VM users :)
Cheers!

sirius

  • Jr. Member
  • **
  • Posts: 93
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: "Customer note" textarea saves ASCII characters in database
« Reply #2 on: February 22, 2021, 10:08:48 am »
Hi,
I can confirm this and already open a topic on this too, because of custom titles of categories or products:
https://forum.virtuemart.net/index.php?topic=145580

You can have a look on this one too:
https://forum.virtuemart.net/index.php?topic=140498
J3.9.24 | PHP7.4.15 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

serazoo

  • Beginner
  • *
  • Posts: 33
Re: "Customer note" textarea saves ASCII characters in database
« Reply #3 on: February 22, 2021, 14:07:13 pm »
Thx Sirius, I've read all posts on this.. I did use the Alt 0146 for the apostrophe when I first saw the problem in my child products.

I can deal with child products myself.. but the most annoying thing is Customer's note, I honestly can tell all my clients to Alt the 3 characters : &#13   &#10   &#39  I receive in Customer's note.

There must be a better solution, I can't believe we are the only 2 with this issue  :-\

Thx everyone for your time :)