Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115542 views)
- Error no. 2003: Can't connect... (52193 views)
- Error no. 1251: "Client does not support authentication..." (48124 views)
- Error no. 1045: "Connection denied..." (41404 views)
- SQLyog Version History (40019 views)
- What is HTTP-tunneling? (29333 views)
- Error No. 2005: Unknown MySQL server host... (28435 views)
- What Is SSH and SSH-tunneling? (25527 views)
- Why are Stored Procedures not created when I import ... (23541 views)
- Do I need PHP to use SQLyog with MySQL? ... (21546 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Working with Views, Stored Procedures and Triggers
Error Code 1305: Problems with non-english characters in Stored Procedures.
There are problems with non-english characters in Stored Procedures. Various errors occur when SP name, parameter(s), and (internal) variables contains such non-english character(s)
For instance this SQL (with Danish characters)
DELIMITER //;
DROP PROCEDURE IF EXISTS ´test´.´æøå´//
CREATE PROCEDURE ´test´.´æøå´ ()
BEGIN
set @test = 'thisisatest';
END//
DELIMITER ;//
creates the SP ´æøå´ (and it shows up in SQLyog Object Browser), but this SQL
call ´test´.´æøå´();
returns
Error Code : 1305
PROCEDURE test.æøå does not exist
(10 ms taken)
The issue is fixed with MySQL 5.0.15 (first non-beta/rc release)
Tags: -
Related entries:
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- Installation and upgrading
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
Last update: 2005-09-24 22:36
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ