Flutter中Text组件显示特殊字符及sqlJocky解码异常解决方案咨询

Got it, let's break down your two Flutter-related problems with clear, actionable solutions:

Flutter's Text widget natively supports Unicode characters, so you have two straightforward options depending on how you're getting the characters:

• Option 1: Directly use the character in your string
  If you're writing the text directly in your code, just include the special character normally—Flutter handles it out of the box:

  Text("Olá, mundo! ç ~");
  

• Option 2: Decode HTML entities (if you're getting encoded strings like ç)
  If your input is HTML-encoded, you'll need to convert those entities to actual characters. Use the html package for this:

  1. Add the dependency to your pubspec.yaml:

     dependencies:
       html: ^0.15.4 # Use the latest version available
     

  2. Import and use HtmlUnescape to decode the string:

     import 'package:html/parser.dart' show HtmlUnescape;
     
     final unescape = HtmlUnescape();
     String encodedText = "ç ~ ´";
     String decodedText = unescape.convert(encodedText);
     
     Text(decodedText); // Will display "ç ~ ´"
     

The garbled characters issue almost always stems from mismatched character encodings between your app, the MySQL connection, and the database itself. Here's how to fix it step by step:

Step 1: Verify your database/table encoding #

First, make sure your MySQL database, tables, and relevant columns are using utf8mb4 (the full Unicode standard, which supports all special characters—avoid the limited utf8 encoding):

• Run this query in your MySQL client to check settings:

  SHOW VARIABLES LIKE 'character_set%';
  

  Ensure character_set_database, character_set_table, character_set_client, and character_set_connection are all set to utf8mb4.

Step 2: Specify charset in your sqlJocky connection #

When creating your ConnectionSettings, explicitly set the charset to utf8mb4 to align with your database:

import 'package:sqljocky5/sqljocky.dart';

void fetchData() async {
  final settings = ConnectionSettings(
    host: 'your_host',
    port: 3306,
    user: 'your_username',
    password: 'your_password',
    db: 'your_database',
    charset: 'utf8mb4', // Critical line to fix encoding mismatches
  );

  var conn = await MySqlConnection.connect(settings);
  Results result = await (await conn.execute('SELECT * FROM SATISFACAO_PERGUNTAS')).deStream();
  
  // Your result should now display special characters correctly
  print(result);
  
  await conn.close();
}

Step 3: Explicitly set connection charset (if needed) #

In rare cases where the above doesn't work, force the connection to use utf8mb4 right after connecting with a raw query:

await conn.execute("SET NAMES 'utf8mb4'");

This ensures all data transferred between your Flutter app and MySQL uses the correct Unicode encoding, eliminating garbled characters.

内容的提问来源于stack exchange，提问作者Micael