Actions409
- Project Actions
- Project Delete Project Invite
- Project Get Project Invite
- Project Delete Project Membership
- Project Get Project Membership
- Project Update Project Membership
- Project Delete Project
- Project Get Project
- Project Delete Server Avatar
- Project Request Server Avatar Upload
- Project Get Llm Licence Experimental
- Project Update Llm Licence Experimental
- Project Get Project Token Invite
- Project Get Self Membership For Project
- Project Get Server
- Project Update Project Description
- Project Update Server Description
- Storagespace Get Project Statistics
- Storagespace Get Server Statistics
- Storagespace Replace Project Notification Threshold
- Storagespace Replace Server Notification Threshold
- Project Accept Project Invite
- Project Create Llm Beta Licence Experimental
- Project Get Llm Licences Experimental
- Project Create Project Invite
- Project List Invites For Project
- Project Create Project
- Project Decline Project Invite
- Project Delete Project Avatar
- Project Request Project Avatar Upload
- Project List Memberships For Project
- Project List Project Invites
- Project List Project Memberships
- Project List Projects
- Project List Servers
- Project Resend Project Invite Mail
- Backup Actions
- Backup Create Project Backup Export
- Backup Delete Project Backup Export
- Backup Create Project Backup Schedule
- Backup List Project Backup Schedules
- Backup Create Project Backup
- Backup List Project Backups
- Backup Delete Project Backup Schedule
- Backup Get Project Backup Schedule
- Backup Delete Project Backup
- Backup Update Project Backup Schedule
- Backup Get Project Backup
- Backup Update Project Backup Description
- Cronjob Actions
- App Actions
- App Execute Action
- App Get App
- App Get Appinstallation
- App Patch Appinstallation
- App Uninstall Appinstallation
- App Get Appversion
- App Set Database Users
- App Get Installed Systemsoftware For Appinstallation
- App Get Missing Dependencies For Appinstallation
- App Get Systemsoftware
- App Get Systemsoftwareversion
- App Link Database
- App List Appinstallations For User
- App List Appinstallations
- App Request Appinstallation
- App List Apps
- App List Appversions
- App List Systemsoftwares
- App List Systemsoftwareversions
- App List Update Candidates For Appversion
- App Replace Database
- App Request Appinstallation Copy
- App Retrieve Status
- App Unlink Database
- SSH SFTP User Actions
- Project File System Actions
- Contract Actions
- Contract Cancel Contract Item Termination
- Contract Terminate Contract Item
- Contract Cancel Contract Tariff Change
- Contract Cancel Contract Termination
- Contract Terminate Contract
- Contract Get Base Item Of Contract
- Contract Get Detail Of Contract By Certificate
- Contract Get Detail Of Contract By Domain
- Contract Get Detail Of Contract By Lead Fyndr
- Order List Project Orders
- Contract Get Detail Of Contract By Mail Address
- Contract Get Detail Of Contract By Project
- Contract Get Detail Of Contract By Server
- Contract Get Detail Of Contract Item
- Contract Get Detail Of Contract
- Contract List Contracts
- Invoice Detail
- Invoice Get Detail Of Invoice Settings
- Invoice Update Invoice Settings
- Invoice Get File Access Token
- Invoice List Customer Invoices
- Order Create Order
- Order List Orders
- Order Create Tariff Change
- Order Get Order
- Order List Customer Orders
- Order Preview Order
- Order Preview Tariff Change
- Database Actions
- Database List Mysql Charsets
- Database List Mysql Versions
- Database List Redis Versions
- Database Create Mysql Database
- Database List Mysql Databases
- Database Create Mysql User
- Database List Mysql Users
- Database Create Redis Database
- Database List Redis Databases
- Database Delete Mysql Database
- Database Get Mysql Database
- Database Delete Mysql User
- Database Get Mysql User
- Database Update Mysql User
- Database Delete Redis Database
- Database Get Redis Database
- Database Disable Mysql User
- Database Enable Mysql User
- Database Get Mysql User Php My Admin Url
- Database Update Mysql Database Default Charset
- Database Update Mysql Database Description
- Database Update Mysql User Password
- Database Update Redis Database Configuration
- Database Update Redis Database Description
- Domain Actions
- Domain Abort Domain Declaration
- Domain Check Domain Registrability
- Domain Check Domain Transferability
- Domain Create Domain Auth Code
- Domain Delete Domain
- Domain Get Domain
- Domain Get Latest Screenshot
- Domain List Tld Contact Schemas
- Domain Resend Domain Email
- Domain Update Domain Auth Code
- Domain Update Domain Contact
- Domain Update Domain Project Id
- Domain List Domains
- Domain Update Domain Nameservers
- Ingress Update Ingress Paths
- Ingress Update Ingress Tls
- Dns Create Dns Zone
- Dns Delete Dns Zone
- Dns Get Dns Zone
- Dns Get Zone File
- Dns List Dns Zones
- Dns Set Record Set Managed
- Dns Update Record Set
- Domain Suggest
- Ingress Create Ingress
- Ingress List Ingresses
- Ingress Delete Ingress
- Ingress Get Ingress
- Ingress Ingress Verify Ownership
- Ingress List Ingresses Compatible With Certificate
- Ingress Request Ingress Acme Certificate Issuance
- Ssl Check Replace Certificate
- Ssl Create Certificate Request
- Ssl List Certificate Requests
- Ssl Delete Certificate Request
- Ssl Delete Certificate
- Ssl Get Certificate Request
- Ssl Get Certificate
- Ssl Replace Certificate
- Ssl List Certificates
- User Actions
- User Update Account
- User Delete Api Token
- User Edit Api Token
- User Get Api Token
- User Delete Ssh Key
- User Edit Ssh Key
- User Get Ssh Key
- User Delete User
- User Get Personalized Settings
- User Update Personalized Settings
- User Get Poll Status
- User Post Poll Status
- Password Validation Get Password Policy
- User Add Phone Number
- User Remove Phone Number
- User Authenticate Mfa
- User Authenticate
- User Authenticate With Access Token Retrieval Key
- User Change Email
- User Change Password
- User Confirm Mfa
- User Disable Mfa
- User Reset Recoverycodes
- User Confirm Password Reset
- User Create Api Token
- User List Api Tokens
- User Create Feedback
- User Create Ssh Key
- User List Ssh Keys
- User Get Session
- User Terminate Session
- User Get User
- User Update Personal Information
- User Init Password Reset
- User List Feedback
- User List Sessions
- User Refresh Session
- User Oauth Retrieve Access Token
- User Register
- User Remove Avatar
- User Request Avatar Upload
- User Resend Verification Email
- User Support Code Request
- User Verify Email
- User Verify Phone Number
- User Verify Registration
- Conversation Actions
- Conversation Create Conversation
- Conversation List Conversations
- Conversation Create Message
- Conversation List Messages By Conversation
- Conversation Get Category
- Conversation Get Conversation Members
- Conversation Get Conversation Preferences Of Customer
- Conversation Get Conversation
- Conversation Update Conversation
- Conversation Get File Access Token
- Conversation Request File Upload
- Conversation Set Conversation Status
- Conversation Update Message
- Customer Actions
- Customer Accept Customer Invite
- Customer Create Customer Invite
- Customer List Invites For Customer
- Customer Create Customer
- Customer List Customers
- Customer Create Recommendation Suggestion
- Customer Create Wallet
- Customer Get Wallet
- Customer Decline Customer Invite
- Customer Delete Customer Invite
- Customer Get Customer Invite
- Customer Delete Customer Membership
- Customer Get Customer Membership
- Customer Update Customer Membership
- Customer Delete Customer
- Customer Get Customer
- Customer Update Customer
- Customer Get Customer Token Invite
- Customer Is Customer Legally Competent
- Customer List Customer Invites
- Customer List Customer Memberships
- Customer List Memberships For Customer
- Customer Remove Avatar
- Customer Request Avatar Upload
- Customer Resend Customer Invite Mail
- Mail Actions
- Mail Create Mail Address
- Mail List Mail Addresses
- Mail Update Mail Address Autoresponder
- Mail Update Mail Address Forward Addresses
- Mail Update Mail Address Password
- Mail Update Mail Address Quota
- Mail Update Mail Address Spam Protection
- Mail Create Deliverybox
- Mail List Delivery Boxes
- Mail Delete Delivery Box
- Mail Get Delivery Box
- Mail Delete Mail Address
- Mail Get Mail Address
- Mail Disable Mail Archive
- Mail List Backups For Mail Address
- Mail List Project Mail Settings
- Mail Recover Mail Address Emails
- Mail Update Delivery Box Description
- Mail Update Delivery Box Password
- Mail Update Mail Address Address
- Mail Update Mail Address Catch All
- Mail Update Project Mail Setting
- Notification Actions
- File Actions
- Page Insights Actions
- Relocation Actions
- Marketplace Actions
- Contributor Delete Contributor
- Contributor Patch Contributor
- Extension Get Contributor
- Contributor Express Interest To Contribute
- Contributor Get Billing Information
- Contributor Update Billing Information
- Contributor Get Customer Billing Portal Link
- Contributor Get Login Link
- Contributor List Contract Partners Of Contributor
- Extension Get Extension Instance For Customer
- Extension Get Extension Instance For Project
- Contributor List Incoming Invoices
- Contributor List Onbehalf Invoices
- Contributor Receipt Get File Access Token
- Contributor Request Deviating Contributor Avatar Upload
- Contributor Reset Contributor Avatar
- Contributor Request Verification
- Contributor Rotate Secret For Extension Instance
- Extension Authenticate Instance
- Extension Authenticate With Session Token
- Extension Cancel Extension Termination
- Extension Schedule Extension Termination
- Extension Change Context
- Extension Consent To Extension Scopes
- Extension Create Contributor Onboarding Process
- Extension Create Extension Instance
- Extension List Extension Instances
- Extension Create Retrieval Key
- Extension Delete Extension Instance
- Extension Get Extension Instance
- Extension Delete Extension
- Extension Get Own Extension
- Extension Patch Extension
- Extension Disable Extension Instance
- Extension Dry Run Webhook
- Extension Enable Extension Instance
- Extension Generate Extension Secret
- Extension Generate Session Token
- Extension Get Customer Extension Instance Orders
- Extension Get Extension Instance Contract
- Extension Update Extension Instance Contract
- Extension Get Extension
- Extension Get Project Extension Instance Orders
- Extension Get Public Key
- Extension Invalidate Extension Secret
- Extension List Contributors
- Extension List Extensions
- Extension List Own Extensions
- Extension Register Extension
- Extension Order Extension
- Extension Remove Asset
- Extension Remove Logo
- Extension Request Logo Upload
- Extension Request Asset Upload
- Extension Request Extension Verification
- Extension Set Extension Published State
- Extension Update Extension Pricing
- Marketplace Customer Get Payment Method
- Marketplace Customer Update Payment Method
- Article Actions
- Container Actions
- Container Create Registry
- Container List Registries
- Container Declare Stack
- Container Get Stack
- Container Update Stack
- Container Delete Registry
- Container Get Registry
- Container Update Registry
- Container Delete Volume
- Container Get Volume
- Container Get Container Image Config
- Container Get Service Logs
- Container Get Service
- Container List Services
- Container List Stacks
- Container List Volumes
- Container Pull Image For Service
- Container Recreate Service
- Container Restart Service
- Container Start Service
- Container Stop Service
- Container Validate Container Registry Uri
- Container Validate Registry Credentials
- Misc Actions
- Lead Fyndr Actions
- Leadfyndr Create Lead Fyndr Access Request
- Leadfyndr Get Lead Fyndr Profile Request
- Leadfyndr Get Cities
- Leadfyndr Get Lead Fyndr Profile Tariff Options
- Leadfyndr Get Lead Fyndr Profile
- Leadfyndr Get Lead
- Leadfyndr Get Unlocked Lead
- Leadfyndr Unlock Lead
- Leadfyndr List Leads
- Leadfyndr List Unlocked Leads
- Leadfyndr Remove Unlocked Lead Reservation
- Leadfyndr Reserve Unlocked Lead
Overview
This node operation updates the default character set settings of a specified MySQL database. It is useful when you need to change or configure the character encoding for a MySQL database to ensure proper storage and retrieval of text data, especially in multilingual environments or when migrating databases with different charset requirements.
Practical examples include:
- Changing the default charset of a MySQL database from
latin1toutf8mb4to support full Unicode characters. - Adjusting collation and charset settings to optimize database behavior for specific language requirements.
Properties
| Name | Meaning |
|---|---|
| Mysql Database Id | The unique identifier of the MySQL database whose default charset settings will be updated. |
| Character Settings | JSON object containing the new character set configuration to apply to the database. This typically includes charset and collation details. |
Output
The node outputs JSON data representing the result of the update operation on the MySQL database's default charset settings. This output usually contains confirmation of the applied changes or the updated database metadata reflecting the new charset configuration.
No binary data output is involved in this operation.
Dependencies
- Requires an API key credential to authenticate requests to the backend service managing the MySQL databases.
- Depends on connectivity to the external API endpoint that handles MySQL database management.
- The node uses JSON-formatted input for character settings, so valid JSON must be provided.
Troubleshooting
- Invalid Mysql Database Id: If the provided database ID does not exist or is incorrect, the node may return an error indicating the database was not found. Verify the ID before running the node.
- Malformed Character Settings JSON: Providing invalid JSON or missing required charset properties can cause request failures. Ensure the JSON is well-formed and includes all necessary charset parameters.
- Authentication Errors: Missing or invalid API credentials will prevent the node from executing successfully. Confirm that the API key credential is correctly configured.
- API Connectivity Issues: Network problems or API downtime can cause timeouts or connection errors. Check network status and API availability.