Re: Arabic text in mysql Varchar row

[Mark Webley]

Hi Rick I have the following results:


proc for select--
SHOW CREATE PROCEDURE getProc;
+------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation |
+------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| getProc| | CREATE DEFINER=`xxxx`@`localhost` PROCEDURE `getProc`(IN x INT)
BEGIN
SELECT
user.title,
user.company,
user.description
FROM
use
WHERE
user.whatever = x
END
| utf8 | utf8_general_ci | latin1_swedish_ci |
+------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+


Proc for insert--
SHOW CREATE PROCEDURE setUser:
+------------------------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| Procedure | sql_mode | Create Procedure | character_set_client | collation_connection | Database Collation |
+------------------------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+
| setUser | | CREATE DEFINER=`xxxx`@`localhost` PROCEDURE `setUser`(IN y INT, IN b VARCHAR(255), IN v VARCHAR(255), IN w VARCHAR(255), IN x BLOB, IN f TIMESTAMP)
BEGIN
UPDATE user SET
title = v,
company = w,
description = x,
WHERE whatever = y


END | utf8 | utf8_general_ci | latin1_swedish_ci |
+------------------------------+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+