php – Page does not return UTF8 characters stored in the MySQL database

Well, I put a website on a server, the database data is in UTF8, I have already checked the server information with:

show variables like '%char%';

And it returns:

character_set_client
utf8mb4
character_set_connection
utf8mb4
character_set_database
utf8
character_set_filesystem
binary
character_set_results
utf8mb4
character_set_server
latin1
character_set_system
utf8
character_sets_dir
/usr/share/percona-server/charsets/

In the database they are in UTF8, and on my HTML page I have already inserted UTF8 for the return. A note I get the data with PHP. So the problem is that it doesn't return in UTF8.

Create a stored procedure in MySQL with WorkBench with 2 or more variables (MariaDB).

Good evening everyone.

First of all, I make it clear that I am new to MySQL and want to transfer a database structure from MS SQL to MySQL. I find a number of differences that I am trying to solve, but I can no longer find the solution.

My problem is as follows: I want to create the following SP:

CREATE PROCEDURE `SP_NPC` (
in P_IdP int, 
in P_CG double(19,4), 
in P_FV datetime, 
in P_Usuario varchar(50)

)
KICK OFF

declare @V_VC as double,
@V_UL as double,
@V_State varchar (1) = & # 39; A & # 39;

set V_VC = select sum (VwC.PC * pc.C)
by St_P P.
inner join St_PC Pc on pc.IdPR = p.IdP
inner join St_P PcDesc to PcDesc.IdP = pc.IdPI
inner join Vw_LMPCV VwC to VwC.IdP = pc.IdPI
where p.IdP = P_IdP

set @V_UL = select IfNull (max (NL), 0) + 1 from St_PS, where IdP = P_IdP

INSERT INTO (dbo).(St_PS)
       ((IdP)
       ,(NL)
       ,(VL)
       ,(CC)
       ,(CoC)
       ,(US)
       ,(Estado)
       ,(FecAlta)
       ,(Usuario))
 VALUES
       (@P_IdP
       ,@V_UL
       ,@P_FV
       ,@P_CG
       ,@V_VC
       ,@P_CG
       ,@V_Estado
       ,GETDATE()
       ,@P_Usuario)

THE END

Basically, the problem highlights me where I start declaring the variables from the beginning, but it doesn't allow me to see beyond what the problem indicates. Can you help me determine where I'm wrong to know why I'm making a mistake?

greetings

System configuration – Select the option in the configuration that is not stored in the database

I follow the answer to create a table with dropdown list in Store> Configuration.

It looks good, but doesn't save my selected dropdown value in core_config_data Table.

Currently saving the null array is so if I remove the drop down menu and add a text box it works perfectly and also saves data in the database. I think I made a mistake creating the dropdown.

Here is my code:

File: system.xml

    
           
           VendorModuleBlockAdminhtmlFormFieldTemplate
           MagentoConfigModelConfigBackendSerializedArraySerialized
    

File: Template.php

class Template extends AbstractFieldArray
{
  protected $_itemRenderer;

  protected function _prepareToRender()
  {
    $this->addColumn(
        'deliverydays',
        (
            'label' => __('Delivery Days'),
            'readonly'=>'readonly',
            'renderer' => $this->_getRenderer()
        )
    );
    $this->_addAfter = false;
    $this->_addButtonLabel = __('Add More');
  }

  protected function _getRenderer()
  {
    $this->_itemRenderer = $this->getLayout()->createBlock(
        VendorModuleBlockAdminhtmlFormFieldOptions::class, '',
        array('is_render_to_js_template' => true)
    );
    return $this->_itemRenderer;
  }

File: Options.php

class Options extends Select
{
/**
 * @var MagentoEavModelConfig
 */
protected $_eavConfig;

public function __construct(Context $context,
                            MagentoEavModelConfig $eavConfig,
                            array $data = ())
{
    parent::__construct($context, $data);
    $this->_eavConfig = $eavConfig;
}

public function _toHtml()
{
    $html = '';
    return $html;
}

public function setInputName($value)
{
    return $this->setName($value);
}

  public function attributeOptions(){
    $attributeCode = "delivery_days";
    $attribute = $this->_eavConfig->getAttribute('catalog_product', $attributeCode);
    $options = $attribute->getSource()->getAllOptions();
    $attrValues = ();
    foreach ($options as $option) {
        if ($option('value') > 0) {
            $attrValues() = $option('label'); //->getText(); //use '->getText' if attribute is system generated
        }
    }
    return $attrValues;
  }
}

C # – how are multiple values ​​stored in a single field in a server table?

I'm developing a program that registers phone accounts that contain multiple numbers and their respective values ​​in that account. I want to know how these two values ​​are stored in an SQL database.

Access to the elements of tables that are stored in lists

I have a list of tables

Psilist={psi0, psi1}

Where psi0 and psi1 are 2D tables. I want to be able to call a specific element of the table in a specific element of the list. e.g. Call the item [[2, 2]] from the table in Psilist [[2]].

I've already tried

Psilist[[2]][[2, 2]]

and the use of a dummy variable. I want to save the tables in a list because I have to go through different time steps and use values ​​from the previous matrix. Any solutions or workarounds would be appreciated.

Where is the Android photo album map stored?

The Android 10 Photo Viewer / Google Photo app offers the possibility to assign a picture to a photo album. This assignment is saved even if the file is moved.

Where is this assignment stored? Is it somehow accessible in EXIF ​​data or in the JPEG file itself? Is there an Android API for photo albums? My goal is to sync these album assignments with a computer.

This question is not Google Photos’s cloud service, which also syncs albums.

Thank you very much

Storage space – With MS SQL Server + Multiple files in one file group -> When is data in the 2nd file stored in the file group?

In a previous question it was suggested to add an additional "file" to my existing (primary) filegroup to easily add more space to my database.

So I did that and nothing broke.

But I'm not sure when SQL Server will decide to stop copying the data to the original file and to copy the data to the new file?

From @ davidbrowne's excellent answer to my question, he mentioned:

SQL Server uses a "proportional fill algorithm" when a fileset contains multiple files.

Okay, great – but when & # 39; knows & # 39; it to fill the other file?

Currently this is what I have set up … and please note the maximum file size.

Enter image description here

Do I have to enter a MAX file size (e.g. LIMIT to 1 T) for the original file so that Sql Server recognizes when the next (new) file should be used?

Currently 19 GB are still available on the hard disk F:,

Where is the Android photo album map stored?

The Android 10 Photo Viewer / Google Photo app offers the possibility to assign a picture to a photo album. This assignment is saved even if the file is moved.

Where is this assignment stored? Is it somehow accessible in EXIF ​​data or in the JPEG file itself? Is there an Android API for photo albums? My goal is to sync these album assignments with a computer.

This question is not Google Photos’s cloud service, which also syncs albums.

Thank you very much