Changing Character_Set_client an Collation_connection for a stored procedure

1

Hi,

Quick question. We have a stored procedure on a database, everytime it is created, it’s created as character_set_client utf8 and collation_connection is utf8_general_ci.

I need these to be latin1 and latin1_swedish_ci. All other databases with the same stored proc are in latin1.

I have tried to drop the stored proc, and create it while setting CHARACTER SET latin1 COLLATE latin1_swedish_ci, but it still shows up as utf8.utf8_general_ci

CREATE DEFINER=sqlserver@% PROCEDURE GetOnboardingConnected(
IN param1 VARCHAR(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci
IN _eobDocumentId INT,
IN _vendorLanguage CHAR(255),
IN _employeeLanguage CHAR(255),
IN _assignmentLanguage CHAR(255)

Let me know if more information is needed, hope this makes sense, im not an expert on MySQL/Postgres

image
image1254×433 39.9 KB

2

Hi, try setting the parameters at session level before running the create procedure statement using
SET NAMES, then check with:

SHOW VARIABLES LIKE 'character%';
SHOW VARIABLES LIKE 'collation%';