Skip to Content Skip to Menu

utf 8

  • nooran
  • nooran
  • OFFLINE
  • Posts: 17
  • Thanks: 0
  • Karma: 0
10 years 8 months ago #241352 by nooran
utf 8 was created by nooran
Hello
I want update field after one trigger. I used auto action filed and its worked exactly but when my value is "Persian language" (utf8 value) after save action my value changed to question mark (???).
this happen in query action too.
Is there any way for update field with utf8 value?

Thanks

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 8 months ago #241387 by krileon
Replied by krileon on topic utf 8
It shouldn't have any issues with valid UTF8 characters. Does storing a valid UTF8 character directly to a field in profile edit work fine? If it also bugs there then it could be a database collation issue.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • nooran
  • nooran
  • OFFLINE
  • Posts: 17
  • Thanks: 0
  • Karma: 0
10 years 8 months ago #241443 by nooran
Replied by nooran on topic utf 8
Yes, in frontend when user changed his data from profile edit and in backend when admin changed data from CB user manager, value updated without any bugs.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
10 years 8 months ago #241463 by krileon
Replied by krileon on topic utf 8
Try using a query action as follows and see if it does the same.

Code:
UPDATE `#__comprofiler` SET `YOUR_FIELD_NAME_HERE` = 'YOUR_VALU_HERE' WHERE `id` = '[user_id]'

Replace YOUR_FIELD_NAME_HERE with the actual name of the field (e.g. cb_myfield) then add the value that you were using in your field action for YOUR_VALU_HERE. This is a direct database update query to the users CB row.

Please also ensure you're using the latest release of CB Auto Actions (5.1.3).


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum