An values format error occurred while using Traditional Chinese

[eric2chek]

Need help~~

• An error occurred when I tried to add a attribute with Chinese

• After testing the following format combinations, none of them can be written to the database.

  • #機密#可用性#完整性
  • #機密 #可用性 #完整性

• Mysql config follow the guidelines

  • CREATE DATABASE deming CHARACTER SET utf8 COLLATE utf8_general_ci;

[eric2chek]

the charset is utf8mb4_unicode_ci

[eric2chek]

found a solution

• sudo nano /var/www/deming/app/Http/Controllers/AttributeController.php

• /* remove => |regex:/^(#[a-zA-Z0-9_èéÉ']+ )$/
  'values' => 'required|regex:/^(#[a-zA-Z0-9_èéÉ']+ )$/|max:4000',
  */
• 'values' => 'required|max:4000',

• both function about store 、 update
• it working now

[dbarzin]

Thanks a lot for this. I will change the code with your proposal.

[dbarzin]

So after some tests, I come with another solution that works better :

'values' => "required|regex:/^(#[\p{L}\p{M}\p{N}'_-]+ *)*$/u|max:4000",

It has been tested with

 #Bonjour #Éducation #DéjàVu #你好
 #Café #Mélange #Résumé #开发
 #Tag123 #Hello_World #L'été

[eric2chek]

thanks for your work !!!

[dbarzin]

Commited here : #133